Categories
- All Categories
- 4 Oracle Analytics Videos
- 13.7K Oracle Analytics Forums
- 5.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 57 Oracle Analytics News
- 31 Oracle Analytics Trainings
- 53 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Security Console Tables
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.).
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 Report0 -
Rachel - where would I find these reports? I did a search and cannot find anything. Maybe I am not in the right spot?
0 -
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.
0 -
Hi Rachel
Thank you so much, we have managed to get the information we needed!
0 -
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
0