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

1. Oracle PL / SQL
2. System Tables Views
3. USER_COL_PRIVS_RECD

Privileges on columns of objects in other schemas granted to the user

SQL> --Privileges on columns of objects in other schemas granted to the user
SQL>
SQL> desc USER_COL_PRIVS_RECD;
 Name                                                                                                  Null?    Type
 ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
 OWNER                                                                                                 NOT NULL VARCHAR2(30)
 TABLE_NAME                                                                                            NOT NULL VARCHAR2(30)
 COLUMN_NAME                                                                                           NOT NULL VARCHAR2(30)
 GRANTOR                                                                                               NOT NULL VARCHAR2(30)
 PRIVILEGE                                                                                             NOT NULL VARCHAR2(40)
 GRANTABLE                                                                                              VARCHAR2(3)

SQL>
SQL> select * from USER_COL_PRIVS_RECD;

no rows selected

SQL>
SQL>
           
       

Related examples in the same category