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

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>