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

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

Column object privileges: user_col_privs_made

SQL> desc user_col_privs_made;
 Name             Null?    Type
 GRANTEE          NOT NULL VARCHAR2(30) --User to whom the privilege was granted.
 TABLE_NAME       NOT NULL VARCHAR2(30) --Name of the object on which privilege was granted.
 COLUMN_NAME      NOT NULL VARCHAR2(30) --Name of the object on which privilege was granted.
 GRANTOR          NOT NULL VARCHAR2(30) --User who granted the privilege.
 PRIVILEGE        NOT NULL VARCHAR2(40) --Privilege on the object.
 GRANTABLE                 VARCHAR2(3)  --Whether the grantee can grant the privilege to another. Equal to YES or NO.
SQL>
SQL> SELECT *
  2  FROM user_col_privs_made;
SQL>
SQL>