Oracle PL/SQL/System Tables Views/USER COL PRIVS RECD
Версия от 13:45, 26 мая 2010; (обсуждение)
Privileges on columns of objects in other schemas granted to the user
SQL> --Privileges on columns of objects in other schemas granted to the user
SQL>
SQL> desc USER_COL_PRIVS_RECD;
Name Null? Type
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
OWNER NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME NOT NULL VARCHAR2(30)
GRANTOR NOT NULL VARCHAR2(30)
PRIVILEGE NOT NULL VARCHAR2(40)
GRANTABLE VARCHAR2(3)
SQL>
SQL> select * from USER_COL_PRIVS_RECD;
no rows selected
SQL>
SQL>