DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.ALL_TAB_PRIVS_MADE

Object Details
Object Name: ALL_TAB_PRIVS_MADE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

User's grants and grants on user's objects

[View Source]

Columns
Name Datatype Length Mandatory Comments
GRANTEE VARCHAR2 (128)
Name of the user to whom access was granted
OWNER VARCHAR2 (128)
Owner of the object
TABLE_NAME VARCHAR2 (128)
Name of the object
GRANTOR VARCHAR2 (128)
Name of the user who performed the grant
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)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRANTEE
,      OWNER
,      TABLE_NAME
,      GRANTOR
,      PRIVILEGE
,      GRANTABLE
,      HIERARCHY
,      COMMON
,      TYPE
FROM SYS.ALL_TAB_PRIVS_MADE;

Dependencies

[top of page]

SYS.ALL_TAB_PRIVS_MADE references the following:

SchemaSYS
TableOBJAUTH$
TableTABLE_PRIVILEGE_MAP
TableUSER$
TableUSERAUTH$
TableUSER_PRIVILEGE_MAP
View_CURRENT_EDITION_OBJ
SYS.ALL_TAB_PRIVS_MADE is referenced by following:

SchemaPUBLIC
SynonymALL_TAB_PRIVS_MADE