Oracle Business Intelligence Applications

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

Categories

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

Oracle BI EE report/dashboard authorization

Received Response
1
Views
1
Comments
User_OKSXP
User_OKSXP Rank 1 - Community Starter
in Oracle Business Intelligence Applications

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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.