Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report that provides a list of permissions for all folders in BI Catalog

2771
Views
68
Comments
12346

Comments

  • Rank 1 - Community Starter

    Providing a report listing permissions for BI objects (or at least letting us know which tables to query for it) is a critical need for many Oracle clients.

  • Rank 1 - Community Starter

    +1 very much needed functionality

  • Rank 4 - Community Specialist

    We are not querying the tables. We are using REST APIs of OAC to pull the data and store the outcome JSON file Locally.

    Using the JSON File Transform the output to a CSV file taking the required information from the JSON file.

    Uploading the resultant CSV file as a Dataset and building a report as an example, you can even develop DV workbooks using the Dataset.

    It is not for FA OTBI. It is only for OAC.

  • Rank 1 - Community Starter

    Agree, this is useful foraudit control of access to Reports.

  • Rank 2 - Community Beginner

    Oh, wow, this is really needed. The amount of time our security admin spends on this checking this could be measured in weeks by this point. Would save so much time/energy/resources for our company.

  • Rank 1 - Community Starter

    That will be great if we have this report to list the permission setup of the report.

  • Rank 5 - Community Champion

    Upvoted. Would make an easy reference point.

  • Rank 1 - Community Starter

    Just given the task to document the folder permissions set up on our 3 environments to confirm alignment. 1st stop was to see if there is a method to extract this information in bulk and run a compare program. Alas, it is yet to be developed for OBTI. This would indeed be a useful tool to support the system security and data access through reporting.

    Angie - TI Workforce Solutions

  • Rank 7 - Analytics Coach

    This is must. This will save a lot of time for the developer + identifying access issues.

  • Rank 0 - Community Observer

    Would love to see this report!

Welcome!

It looks like you're new here. Sign in or register to get started.