Oracle Transactional Business Intelligence

Security Console Tables

Received Response
183
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

Answers

  • 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

  • Prudence K
    Prudence K ✭✭✭✭

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

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

  • Aaron Leggett
    Aaron Leggett ✭✭✭✭

    Hi Rachel

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

  • 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