ALL_TAB_PRIVS
describes the following types of grants:
Object grants for which the current user is the object owner, grantor, or grantee
Object grants for which an enabled role or PUBLIC
is the grantee
Related Views
DBA_TAB_PRIVS
describes all object grants in the database.
USER_TAB_PRIVS
describes the object grants for which the current user is the object owner, grantor, or grantee.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the user who performed the grant |
|
|
|
Name of the user or role to whom access was granted |
|
|
|
Schema of the object |
|
|
|
Name of the object |
|
|
|
Privilege on the object |
|
|
|
Indicates whether the privilege was granted with the |
|
|
|
Indicates whether the privilege was granted with the |
|
|
|
Indicates how the grant was made. Possible values:
|
|
|
|
Type of the object |
See Also: