Object privileges on a table: user_tab_privs_recd table : user_tab_privs_recd « System Tables Data Dictionary « Oracle PL/SQL Tutorial






Some Columns in user_tab_privs_recd
Column       Description
owner        User who owns the object.
table_name        Name of the object on which the privilege was granted.
grantor        User who granted the privilege.
privilege        Privilege on the object.
grantable        Whether the grantee can grant the privilege to another. Equal to YES or NO.
hierarchy        Whether the privilege forms part of a hierarchy. Equal to YES or NO.


SQL>
SQL> --CONNECT steve/button
SQL> SELECT *
  2  FROM user_tab_privs_recd;








30.104.user_tab_privs_recd
30.104.1.Object privileges on a table: user_tab_privs_recd table