Oracle Analytics Cloud and Server

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
Rank 2 - Community Beginner

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • 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.

  • 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.

  • 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!!

  • Rank 2 - Community Beginner

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

Welcome!

It looks like you're new here. Sign in or register to get started.