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)
Column | Description |
grantee | User to whom the privilege was granted. |
table_name | Name of the object (such as a table) on which privilege was granted. |
grantor | User who granted the privilege. |
privilege | Privilege on the object. |
grantable | Whether the grantee can grant the privilege to another. Equal to YES or NO. |
hierarchy | Whether 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 |