DBA_ROLES view tips

Oracle Tips by Burleson Consulting

DBA_ROLES

<< Return to the index

Oracle 11g makes the following comments about the DBA_ROLES table: "All Roles which exist in the database"

Related notes on DBA_ROLES:

Column description of the DBA_ROLES view:

ROLE

Description of DBA_ROLES.ROLE: "Role Name"

PASSWORD_REQUIRED

Description of DBA_ROLES.PASSWORD_REQUIRED: "Indicates if the role requires a password to be enabled"

DBA_ROLES View Source

Oracle 11g's data dictionary defines the DBA_ROLES view using the following source query:

select name, decode(password, null, 'NO', 'EXTERNAL', 'EXTERNAL',
'GLOBAL', 'GLOBAL', 'YES')
from user$
where type# = 0 and name not in ('PUBLIC', '_NEXT_USER')

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books