Home » RDBMS Server » Security » Listing Oracle Roles
Listing Oracle Roles [message #16721] Thu, 09 December 2004 05:11 Go to next message
Chris
Messages: 128
Registered: November 1998
Senior Member
I am not setup with a default role.  According to the DBA, I have multiple roles.  The DBA staff isn't very helpful though.

 

How can I see all available roles so I can set my role to what I need?
Re: Listing Oracle Roles [message #16722 is a reply to message #16721] Thu, 09 December 2004 05:20 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Try DBA_ROLES, ROLE_SYS_PRIVS or ROLE_TAB_PRIVS. Paradoxically, you may need your DBA to run queries against these views if you do not have access to them.
Re: Listing Oracle Roles [message #16736 is a reply to message #16721] Thu, 09 December 2004 20:21 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Check user_role_privs for roles assigned to you. Check session_roles for roles that are enabled currently.

hth
Previous Topic: System grant select on user table
Next Topic: Oracle Roles
Goto Forum:
  


Current Time: Fri Dec 03 06:30:11 CST 2021