[Home] [Help] [Dependency Information]
Object Name: | ALL_TAB_PRIVS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Grants on objects for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRANTOR | VARCHAR2 | (128) | Name of the user who performed the grant | |
GRANTEE | VARCHAR2 | (128) | Name of the user to whom access was granted | |
TABLE_SCHEMA | VARCHAR2 | (128) | Schema of the object | |
TABLE_NAME | VARCHAR2 | (128) | Name of the object | |
PRIVILEGE | VARCHAR2 | (40) | Table Privilege | |
GRANTABLE | VARCHAR2 | (3) | Privilege is grantable | |
HIERARCHY | VARCHAR2 | (3) | Privilege is with hierarchy option | |
COMMON | VARCHAR2 | (3) | Privilege was granted commonly | |
TYPE | VARCHAR2 | (24) |
Cut, paste (and edit) the following text to query this object:
SELECT GRANTOR
, GRANTEE
, TABLE_SCHEMA
, TABLE_NAME
, PRIVILEGE
, GRANTABLE
, HIERARCHY
, COMMON
, TYPE
FROM SYS.ALL_TAB_PRIVS;
|
|
|