Oracle PL/SQL Tutorial/System Tables Data Dictionary/user tab privs recd
Версия от 13:45, 26 мая 2010; (обсуждение)
30. Object privileges on a table: user_tab_privs_recd table
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;