Home » RDBMS Server » Security » How to get the user created roles
How to get the user created roles [message #6640] Wed, 30 April 2003 03:22 Go to next message
shawlin
Messages: 25
Registered: April 2003
Junior Member
I had created a role.Is there any tables
to look for the role which i had created.

thanks and regards
shawlin
Re: How to get the user created roles [message #6645 is a reply to message #6640] Wed, 30 April 2003 05:55 Go to previous messageGo to next message
jigar
Messages: 74
Registered: July 2002
Member
Connect to Sys as SYSDBA

select * from EXU7ROL;
Re: How to get the user created roles [message #6647 is a reply to message #6645] Wed, 30 April 2003 06:10 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Same as query directly DBA_ROLES ( except u can see th encrypted password )
Previous Topic: Apache Tomcat Form Based Authentication, MD5 and dbms_obfuscation_toolkit.MD5
Next Topic: audit sys.aud$ doesn't work
Goto Forum:
  


Current Time: Thu Mar 28 14:38:16 CDT 2024