Oracle BI EE report/dashboard authorization

Question

Hi all,

is there a way in OBIEE 11 to query for all the reports/dashboards a specific user/group has access to?

I want to remove a group from an user but I'm not sure of the reports/dashboards associated to that specific group.

I imagine there is somewhere a configuration table of metadata where this information is stored in a tabular fashion, right?

Thanks in advance.

Gianni Ceresa · Answer

4225183 wrote:I imagine there is somewhere a configuration table of metadata where this information is stored in a tabular fashion, right?

Imagination isn't always right

ACL is stored into the .atr files in the catalog directly. You can generate reports using Catalog Manager to get the ACL of all the objects and use that for your analysis.

Just keep in mind inheritance: a group can have grants to something without being directly specified in the ACL of the object. Often a group is member of something else and it inherits permissions, so make sure you do a full analysis keeping in mind how the whole security model work.