Oracle PL/SQL Tutorial/System Tables Data Dictionary/user col privs recd
Версия от 13:45, 26 мая 2010; (обсуждение)
Get Object privileges a user has received by querying user_col_privs_recd
SQL> desc user_col_privs_recd;
Name Null? Type
OWNER NOT NULL VARCHAR2(30) --User who owns the object.
TABLE_NAME NOT NULL VARCHAR2(30) --Name of the table on which the privilege was granted.
COLUMN_NAME NOT NULL VARCHAR2(30) --Name of the column 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.
SELECT * FROM user_col_privs_recd;