OraFAQ Forum: Security » Listing Oracle Roles

Home » RDBMS Server » Security » Listing Oracle Roles

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listing Oracle Roles [message #16721]

Thu, 09 December 2004 05:11

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?

Report message to a moderator

Re: Listing Oracle Roles [message #16722 is a reply to message #16721]

Thu, 09 December 2004 05:20

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.

Report message to a moderator

Re: Listing Oracle Roles [message #16736 is a reply to message #16721]

Thu, 09 December 2004 20:21

Frank
Messages: 7901
Registered: March 2000

Senior Member

Check user_role_privs for roles assigned to you. Check session_roles for roles that are enabled currently.

hth

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 01 09:18:17 CDT 2026