Option to get the Permissions associated with BI reports

SM6

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

Praveen Kumar Akkala-Oracle

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

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

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

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

Praveen Kumar Akkala-Oracle

@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