Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Submitted
2759
Views
68
Comments
12346

Comments

  • Rob Turner
    Rob Turner 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.

  • psk_1312
    psk_1312 Rank 1 - Community Starter

    +1 very much needed functionality

  • Veera Raghavendra Rao Koka-Oracle
    Veera Raghavendra Rao Koka-Oracle 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.

  • Diane Stuart
    Diane Stuart Rank 1 - Community Starter

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

  • Monique
    Monique 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.

  • gangcai hu-Oracle
    gangcai hu-Oracle Rank 1 - Community Starter

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

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    Upvoted. Would make an easy reference point.

  • Angela Wagner
    Angela Wagner 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

  • MandeepGupta
    MandeepGupta Rank 7 - Analytics Coach

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

  • Scott P Bullinger
    Scott P Bullinger Rank 0 - Community Observer

    Would love to see this report!