Oracle PL/SQL Tutorial/System Tables Data Dictionary/user tab privs recd — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 16:45, 26 мая 2010
30. Object privileges on a table: user_tab_privs_recd table
<source lang="sql">
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;</source>