Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TAB_PRIVS

Grants on objects for which the user is the owner, grantor or grantee

Columns
   ___________________________
 
   GRANTOR
      Name of the user who performed the grant
   GRANTEE
      Name of the user to whom access was granted
   PRIVILEGE
      Table Privilege
   TABLE_NAME
      Name of the object
   OWNER
      Owner of the object
   GRANTABLE
      Privilege is grantable

Related Views:

 DBA_COL_PRIVS  ALL_COL_PRIVS        USER_COL_PRIVS     COLUMN_PRIVILEGES

 DBA_TAB_PRIVS  ALL_TAB_PRIVS        USER_TAB_PRIVS     TABLE_PRIVILEGES 
                                                        ROLE_TAB_PRIVS 
                ALL_TAB_PRIVS_MADE   USER_TAB_PRIVS_MADE 
                ALL_TAB_PRIVS_RECD   USER_TAB_PRIVS_RECD 




Back to the Top

Simon Sheppard
SS64.com