eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ROLES

Object Details

Object Name:	DBA_ROLES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All Roles which exist in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROLE	VARCHAR2	(128)	Yes	Role Name
PASSWORD_REQUIRED	VARCHAR2	(8)		Depreacted from 11.2 -- use AUTHENTICATION_TYPE instead
AUTHENTICATION_TYPE	VARCHAR2	(11)		Indicates authentication mechanism for the role
COMMON	VARCHAR2	(3)		Indicates whether this role is Common
ORACLE_MAINTAINED	VARCHAR2	(1)		Denotes whether the role was created, and is maintained, by Oracle-supplied scripts. A role for which this has the value Y must not be changed in any way except by running an Oracle-supplied script.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROLE
,      PASSWORD_REQUIRED
,      AUTHENTICATION_TYPE
,      COMMON
,      ORACLE_MAINTAINED
FROM SYS.DBA_ROLES;

Dependencies

[top of page]

SYS.DBA_ROLES references the following:

SYS: USER$

SYS.DBA_ROLES is referenced by following:

CTXSYS: CTX_ADM - show dependent code
DVSYS: DV$SYS_GRANTEE
PUBLIC: DBA_ROLES
SYS: DBMS_LOGREP_UTIL - show dependent code; PRVTEMX_ADMIN - show dependent code