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

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

Privileges that you have granted to others on tables in your schema

   <source lang="sql">

SQL> SQL> -- Privileges that you have granted to others on tables in your schema SQL> SQL> SELECT * FROM USER_TAB_PRIVS_MADE; no rows selected SQL>

      </source>
   
  


Querying the USER_TAB_PRIVS_MADE data dictionary view

   <source lang="sql">

SQL> SQL> SQL> -- Querying the USER_TAB_PRIVS_MADE data dictionary view SQL> SQL> SELECT * FROM USER_TAB_PRIVS_MADE where rownum < 10; GRANTEE TABLE_NAME


------------------------------

GRANTOR PRIVILEGE GRA HIE


---------------------------------------- --- ---

OEM_MONITOR ALERT_QUE SYS DEQUEUE NO NO PUBLIC ALERT_TYPE SYS EXECUTE NO NO PUBLIC ALL_ALL_TABLES SYS SELECT YES NO

GRANTEE TABLE_NAME


------------------------------

GRANTOR PRIVILEGE GRA HIE


---------------------------------------- --- ---

PUBLIC ALL_APPLY SYS SELECT YES NO PUBLIC ALL_APPLY_CONFLICT_COLUMNS SYS SELECT YES NO PUBLIC ALL_APPLY_DML_HANDLERS SYS SELECT YES NO

GRANTEE TABLE_NAME


------------------------------

GRANTOR PRIVILEGE GRA HIE


---------------------------------------- --- ---

PUBLIC ALL_APPLY_ENQUEUE SYS SELECT YES NO PUBLIC ALL_APPLY_ERROR SYS SELECT YES NO PUBLIC ALL_APPLY_EXECUTE SYS SELECT YES NO

9 rows selected. SQL> SQL> SQL>

      </source>