Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

USER_ROLE_PRIVS

USER_ROLE_PRIVS describes the roles granted to the current 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)

Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO)

DEFAULT_ROLE

VARCHAR2(3)

Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)

OS_GRANTED

VARCHAR2(3)

Granted by the operating system (YES) or not (NO); occurs if configuration parameter OS_ROLES = true.