Privileges granted to the user on objects in other schemas
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>
Related examples in the same category