Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Option to get the Permissions associated with BI reports

Received Response
79
Views
5
Comments
SM6
SM6 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

We have noticed that few of our BI reports have permissions which are incorrect and we would want to anlyze all the BI reports and their permissions to correct the same.

Since there are around 300+ reports, we are looking for an option to get the data in a quick way(probably a query, if available) of all Reports and the permissions associated with the reports rather than having to go to the report object, click on More and then look at permissions.


Appreciate, if anyone has any thoughts or options to achive the same please

Answers

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    Hi @SM6 ,

    I guess there is no SQL to get the list of reports associated with the permissions in Fusion SaaS.

    But you can try creating an SR with referencing the below document for support to get the list of reports associated with the permissions.

    Fusion BI - How to Generate a Report of the BI Catalog Objects and Permissions? (Doc ID 2730513.1)


    Thanks,

    Praveen

  • SM6
    SM6 Rank 1 - Community Starter

    Thanks Praveen for your response.

    Unfortunately, I had raised this question since I received a response in the SR to use this community :-) as a solution, so it's just going in circles but I will try to ask the SR suport person once more, if they can help via an SR

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    Hi @SM6,

    Yes, You can refer teh above document in your existing SR and request them to provide the list as we cannot work with internal team and provide the list on Customer Connect as Customer Connect is on general guidance / how to related questions and the info you are looking for might have PII info in it.


    Thanks,

    Praveen

  • SM6
    SM6 Rank 1 - Community Starter

    Thanks Praveen for your response. I'm following up via the SR again now.

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    @SM6 ,

    You are welcome.

    Please let me know if you have any questions and also you can mark this thread as Answered if the issue is resolved.


    Thanks,

    Praveen