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

OBI 11g - SQL query to locate all catalog objects that a specified role has permission

Received Response
1
Views
1
Comments
Glenda Reed
Glenda Reed Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Analytics Forum

Hi,


I would like to find a way to query via SQL to locate all folders and objects within the OBI catalog where a specified role or group has any sort of permission.  Can someone point me in the right direction for that?

Thank you,

Glenda Reed

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi Glenda,

    Out of the box there is not a single piece of info (data or metadata) of the catalog stored in a DB, it's all in the filesystem (the .atr files).

    If you look at SampleApp there are example dashboards and scripts on how to extract that kind of info and load it into a DB (http://slc02okq.oracle.com:7780/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2F10.%20Lifecycle%20and%20Admin%2F_port…)

    You can maybe also try with Catalog Manager and create a report there (didn't try lately so can't remember if you can have a list of objects with permissions).

    Setting up the SampleApp script will take you just 10 minutes, and you can also just run it once by hand and analyze the output with Excel if you don't want to load it in a DB.