DBA_ROLES

Oracle 11gR1

DBA_ROLES lists all roles that exist in the database.

Column	Datatype	NULL	Description
ROLE	VARCHAR2(30)	NOT NULL	Role name
PASSWORD_REQUIRED	VARCHAR2(8)		Indicates if the role requires a password to be enabled

Note:

1.

select * from DBA_ROLES;

ROLE	PASSWORD_REQUIRED
CONNECT	NO
RESOURCE	NO
DBA	NO
SELECT_CATALOG_ROLE	NO
EXECUTE_CATALOG_ROLE	NO
DELETE_CATALOG_ROLE	NO

Oracle data dictionary views