Oracle PL/SQL/System Tables Views/USER TAB PRIVS RECD
Версия от 16:45, 26 мая 2010; (обсуждение)
Privileges granted to the user on objects in other schemas
<source lang="sql">
SQL> set lin 180; SQL> --Privileges granted to the user on objects in other schemas SQL> SQL> desc USER_TAB_PRIVS_RECD;
Name Null? Type ----------------------------------------------------------------------------------------------------- -------- -------------------------------------------------------------------- OWNER NOT NULL VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) GRANTOR NOT NULL VARCHAR2(30) PRIVILEGE NOT NULL VARCHAR2(40) GRANTABLE VARCHAR2(3) HIERARCHY VARCHAR2(3)
SQL> SQL> select * from USER_TAB_PRIVS_RECD; OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE
------------------------------ ------------------------------ ---------------------------------------- --- ---
SYS EXT_DATA_FILES SYS WRITE YES NO SYS EXT_DATA_FILES SYS READ YES NO SQL>
</source>