Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check enabled roles?

Saad NayefFeb 8 2010 — edited Feb 8 2010

*To view all roles in database we have DBA_ROLES which has the following structure:
ROLE NOT NULL VARCHAR2(30) Role Name
PASSWORD_REQUIRED VARCHAR2(8) Indicates if the role requires a password to be enable
By SET ROLE* statement we can enable or disable roles
The parameter MAX_ENABLED_ROLES* determines the maximum enabled roles in the database

How can we check the enabled or disabled roles in database?

Saad,

This post has been answered by Vijayaraghavan Krishnan on Feb 8 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 8 2010

Added on Feb 8 2010

#general-database-discussions

11 comments

2,741 views