Checking Object Privileges Made : user_tab_privs_made « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL> desc user_tab_privs_made;
 Name               Null?    Type
 GRANTEE            NOT NULL VARCHAR2(30)
 TABLE_NAME         NOT NULL VARCHAR2(30)
 GRANTOR            NOT NULL VARCHAR2(30)
 PRIVILEGE          NOT NULL VARCHAR2(40)
 GRANTABLE                   VARCHAR2(3)
 HIERARCHY                   VARCHAR2(3)
ColumnDescription
granteeUser to whom the privilege was granted.
table_nameName of the object (such as a table) on which privilege was granted.
grantorUser who granted the privilege.
privilegePrivilege on the object.
grantableWhether the grantee can grant the privilege to another. Equal to YES or NO.
hierarchyWhether the privilege forms part of a hierarchy. Equal to YES or NO.


SQL> SELECT * FROM user_tab_privs_made;
SQL>
SQL>








30.103.user_tab_privs_made
30.103.1.Checking Object Privileges Made