Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Permissions report for catalog manager objects

Received Response
1
Views
1
Comments
Gaétan Francoeur
Gaétan Francoeur Rank 4 - Community Specialist
edited Aug 13, 2024 6:07PM in Oracle Analytics Forum

Hi,

We have OBIEE 11g and we're trying to find a way to list all objects (analyses, dashboards, prompts, etc) a user could have access to in Answers Shared folders or Catalog manager.

We would also like to be able to list all privileges/permissions of all objects. Who has access to what? For example, if a user creates a dashboard, who has access and with which privileges : author, consumer...

It doesn't seem to exist any report like that in Catalog manager reporting tool.

Any idea?

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    If you look in Sample App (OBIEE Samples ) there are scripts provided to extract all the permissions of all the objects in the catalog and load them into a table of your DB so you can build reports on that. Sample App has few example reports built on that data.