Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Privileges made on columns of objects owned by the user

SQL> --Privileges made on columns of objects owned by the user SQL> SQL> desc USER_COL_PRIVS_MADE;  Name                                                                                                  Null?    Type  ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------  GRANTEE                                                                                               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_MADE; no rows selected SQL>