Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-04 |
|
|
View PDF |
The USER_TAB_PRIVS view lists the object privileges granted to the current user, the object privileges granted by the current user, and the list of object privileges granted for objects owned by the current user.
Related views
SYS.ALL_TAB_PRIVS lists the object privileges granted to the current user, the object privileges granted by the current user, the list of object privileges granted for objects owned by the current user and the object privileges granted to PUBLIC.
SYS.DBA_TAB_PRIVS lists the object privileges granted to all users and to PUBLIC.
Columns
Column | Type | Description |
---|---|---|
GRANTEE | VARCHAR2(30) NOT NULL | Name of the user with the privilege |
OWNER | VARCHAR2(31) NOT NULL | Object owner |
TABLE_NAME | VARCHAR2(31) NOT NULL | Object name |
GRANTOR | VARCHAR2(30) NOT NULL | Name of the user who granted the privilege |
PRIVILEGE | VARCHAR2(40) NOT NULL | Privilege name |
GRANTABLE | VARCHAR2(3) NOT NULL | Value is always NO. |
HIERARCHY | VARCHAR2(3) NOT NULL | Value is always NO. |