OraFAQ Forum: Security » Oracle 8

Home » RDBMS Server » Security » Oracle 8 - users & roles

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

Oracle 8 - users & roles [message #18694]

Mon, 11 February 2002 06:40

Phil
Messages: 32
Registered: March 2001

Member

Can anyone tell me what sql i need to find out what role each user has been allocated to ?

Thanks
Phil

Report message to a moderator

Re: Oracle 8 - users & roles [message #18697 is a reply to message #18694]

Mon, 11 February 2002 07:07

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

select * from dba_role_privs

Report message to a moderator

Re: Oracle 8 - users & roles [message #18700 is a reply to message #18694]

Mon, 11 February 2002 07:35

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

select granted_role from dba_role_privs where grantee='USERNAME'
union
select granted_role from role_role_privs where role in
(select granted_role from dba_role_privs where grantee='USERNAME)

Report message to a moderator

Previous Topic:	how to encrypt and decrypt password field in a table for 8i release 8.1.5
Next Topic:	Creating a new user account in Personal Oracle 8 on Win NT/2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 15:06:21 CDT 2024