Oracle PL/SQL/System Tables Views/USER COL PRIVS MADE

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

Privileges made on columns of objects owned by the user

   <source lang="sql">

SQL> --Privileges made on columns of objects owned by the user SQL> SQL> desc USER_COL_PRIVS_MADE;

Name                                                                                                  Null?    Type
----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
GRANTEE                                                                                               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_MADE; no rows selected SQL>

      </source>