Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_SYS_PRIVS
describes system privileges granted to users and roles. This view does not display the USERNAME
column.
USER_SYS_PRIVS
describes system privileges granted to the current user. This view does not display the GRANTEE
column, but instead displays the USERNAME
column.
Column | Datatype | NULL | Description |
---|---|---|---|
GRANTEE |
VARCHAR2(30) |
NOT NULL |
Grantee name, user, or role receiving the grant |
USERNAME |
VARCHAR2(30) |
Name of the current user | |
PRIVILEGE |
VARCHAR2(40) |
NOT NULL |
System privilege |
ADMIN_OPTION |
VARCHAR2(3) |
Grant was with the ADMIN option |