Permissions report for catalog manager objects

Question

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

Gianni Ceresa · Answer

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.