Security Console Tables

Aaron Leggett

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

 

Rachel Martorelli-Oracle

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

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

Sasmita Babu

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

Hi Rachel

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

Karthik Vinodkumar

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