Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Get ACL of OBIEE Subject area

Received Response
21
Views
4
Comments
2951778
2951778 Rank 2 - Community Beginner
edited August 2024 in Oracle Analytics Cloud and Server

Hello,

We gather provileges on subject areas for security audit. I want to automate this process and dump the subject area privileges into a database table.

I was looking into any pre-built utilities from Oracle but do not find one similar dump_ACL.sh which we have for Webcat. Any suggestions on how to go about it.

Thanks

Abhi

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Abhi,

    Subject Area Privileges are stored in folders under YourCatalogRoot/system/privs/sa%2e%22... with one folder per Subject Area and in there you have the usual ACLs.

    The SampleAp scripts you mention are geared towards content, not system privileges.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @2951778 Did you give up on this? For the benefit of other forum users it is courteous to finish your threads. Sharing goes both ways.

  • Ryadav
    Ryadav Rank 1 - Community Starter

    Hey..I was just trying out different options. But thanks for sharing the info. I will explore writing a shell script to navigate through the folder structure and import data. Thanks for the response!!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Cool. In that case can you please close this thread? It will help other forum users find information more quickly.