Home » RDBMS Server » Security » Oracle 8 - users & roles
Oracle 8 - users & roles [message #18694] Mon, 11 February 2002 06:40 Go to next message
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
Re: Oracle 8 - users & roles [message #18697 is a reply to message #18694] Mon, 11 February 2002 07:07 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
select * from dba_role_privs
Re: Oracle 8 - users & roles [message #18700 is a reply to message #18694] Mon, 11 February 2002 07:35 Go to previous message
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)
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:
  


Current Time: Thu May 26 16:42:36 CDT 2022