v$ Performance views

ALL_COL_PRIVS

Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee

Columns
   ___________________________
 
   PRIVILEGE
      Column Privilege
   GRANTEE
      Name of the user to whom access was granted
   TABLE_SCHEMA
      Schema of the object
   COLUMN_NAME
      Name of the column
   GRANTABLE
      Privilege is grantable
   GRANTOR
      Name of the user who performed the grant
   TABLE_NAME
      Name of the object

Related Views:

 DBA_COL_PRIVS  ALL_COL_PRIVS        USER_COL_PRIVS     COLUMN_PRIVILEGES
                ALL_COL_PRIVS_MADE   USER_COL_PRIVS_MADE
                ALL_COL_PRIVS_RECD   USER_COL_PRIVS_RECD 

 DBA_TAB_PRIVS  ALL_TAB_PRIVS        USER_TAB_PRIVS     TABLE_PRIVILEGES 
                                                        ROLE_TAB_PRIVS 



Back to the Top

Simon Sheppard
SS64.com