USER_ROLE_PRIVS

USER_ROLE_PRIVS lists roles granted to the user.

Column	Datatype	NULL	Description
USERNAME	VARCHAR2(30)		Name of the user, or PUBLIC
GRANTED_ROLE	VARCHAR2(30)		Name of the role granted to the user
ADMIN_OPTION	VARCHAR2(3)		Granted with ADMIN option (YES | NO)
DEFAULT_ROLE	VARCHAR2(3)		Role is designated as the user's default role (YES | NO)
OS_GRANTED	VARCHAR2(3)		Granted by the operating system (YES | NO; occurs if configuration parameter OS_ROLES = TRUE)