Oracle PL/SQL Tutorial/System Tables Data Dictionary/user tab privs made

Материал из SQL эксперт
Перейти к: навигация, поиск

30. Checking Object Privileges Made

   <source lang="sql">

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)</source>
   
  

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.