OraFAQ Forum: Security » How to get the user created roles

Home » RDBMS Server » Security » How to get the user created roles

Wed, 30 April 2003 03:22

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

Wed, 30 April 2003 05:55

jigar
Messages: 74
Registered: July 2002

Member

Connect to Sys as SYSDBA

select * from EXU7ROL;

Wed, 30 April 2003 06:10

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: Tue Jan 13 18:38:01 CST 2026