[Home] [Help] [Dependency Information]
Object Name: | USER_ROLE_PRIVS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Roles granted to current user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USERNAME | VARCHAR2 | (128) | User Name or PUBLIC | |
GRANTED_ROLE | VARCHAR2 | (128) | Granted role name | |
ADMIN_OPTION | VARCHAR2 | (3) | Grant was with the ADMIN option | |
DELEGATE_OPTION | VARCHAR2 | (3) | Grant was with the DELEGATE option | |
DEFAULT_ROLE | VARCHAR2 | (3) | Role is designated as a DEFAULT ROLE for the user | |
OS_GRANTED | VARCHAR2 | (3) | Role is granted via the operating system (using OS_ROLES = TRUE) | |
COMMON | VARCHAR2 | (3) | Role was granted commonly |
Cut, paste (and edit) the following text to query this object:
SELECT USERNAME
, GRANTED_ROLE
, ADMIN_OPTION
, DELEGATE_OPTION
, DEFAULT_ROLE
, OS_GRANTED
, COMMON
FROM SYS.USER_ROLE_PRIVS;
|
|
|