Oracle Transactional Business Intelligence

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

Security Console Tables

Received Response
206
Views
5
Comments

Content

Hi Everyone 

 

Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the right roles to the right people throughout our implementation and I feel this report will give us a much better understanding for our programme team to see what each role gives access too. Below is a screenshot from the Security Console showing what I would like to extract (Role Name, Role Code and Role Description...if possible the type of role too, such as Duty, Data etc.). 

 

securityconsole.png

Welcome!

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

Answers

  • Rank 4 - Community Specialist

    Hello Aaron,
      I'd suggest running the following jobs to get the data you are looking for:

    User Role Membership Report
    User and Role Access Audit Report

  • Rank 5 - Community Champion

    Rachel - where would I find these reports?  I did a search and cannot find anything.  Maybe I am not in the right spot?

  • Rank 1 - Community Starter

    Hi,

     

    Please Go to Navigator > Schedule Processes > search for the process,if you still not able to see than attach IT_SECURITY _Manager role to your user.

    and then give it a try.

  • Rank 5 - Community Champion

    Hi Rachel

    Thank you so much, we have managed to get the information we needed! 

  • Rank 1 - Community Starter

    Hi Rachel,

    I am trying to pull role category into BIP report. But i am not able to find any table which stores this information. Can you please help me in finding out this table name.

    Thanks,

    Karthik

Welcome!

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