Privileges granted to the user on objects in other schemas : USER_TAB_PRIVS_RECD « System Tables Views « Oracle PL / SQL






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