http://www.sqle.ru/index.php?action=history&feed=atom&title=PostgreSQL%2FView%2FUser_Permission 2026-05-24T11:42:37Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=PostgreSQL/View/User_Permission&diff=4950&oldid=prev 2010-05-26T13:45:56Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=PostgreSQL/View/User_Permission&diff=4951&oldid=prev 2010-05-26T10:14:30Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Checking user permissions==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> postgres=#<br /> postgres=# -- Checking user permissions<br /> postgres=#<br /> postgres=# SELECT relname as &quot;Relation&quot;, relacl as &quot;Access permissions&quot;<br /> postgres-# FROM pg_class<br /> postgres-# WHERE relkind IN (&quot;r&quot;, &quot;v&quot;, &quot;S&quot;)<br /> postgres-# AND relname !~ &quot;^pg_&quot;<br /> postgres-# ORDER BY relname;<br /> Relation | Access permissions<br /> ---------------------------------+-----------------------------------------<br /> applicable_roles | {postgres=arwdRxt/postgres,=r/postgres}<br /> check_constraints | {postgres=arwdRxt/postgres,=r/postgres}<br /> column_domain_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> column_privileges | {postgres=arwdRxt/postgres,=r/postgres}<br /> column_udt_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> columns | {postgres=arwdRxt/postgres,=r/postgres}<br /> constraint_column_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> constraint_table_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> data_type_privileges | {postgres=arwdRxt/postgres,=r/postgres}<br /> domain_constraints | {postgres=arwdRxt/postgres,=r/postgres}<br /> domain_udt_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> domains | {postgres=arwdRxt/postgres,=r/postgres}<br /> element_types | {postgres=arwdRxt/postgres,=r/postgres}<br /> enabled_roles | {postgres=arwdRxt/postgres,=r/postgres}<br /> information_schema_catalog_name | {postgres=arwdRxt/postgres,=r/postgres}<br /> key_column_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> parameters | {postgres=arwdRxt/postgres,=r/postgres}<br /> referential_constraints | {postgres=arwdRxt/postgres,=r/postgres}<br /> role_column_grants | {postgres=arwdRxt/postgres,=r/postgres}<br /> role_routine_grants | {postgres=arwdRxt/postgres,=r/postgres}<br /> role_table_grants | {postgres=arwdRxt/postgres,=r/postgres}<br /> role_usage_grants | {postgres=arwdRxt/postgres,=r/postgres}<br /> routine_privileges | {postgres=arwdRxt/postgres,=r/postgres}<br /> routines | {postgres=arwdRxt/postgres,=r/postgres}<br /> schemata | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_features | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_implementation_info | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_languages | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_packages | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_sizing | {postgres=arwdRxt/postgres,=r/postgres}<br /> sql_sizing_profiles | {postgres=arwdRxt/postgres,=r/postgres}<br /> subjects |<br /> table_constraints | {postgres=arwdRxt/postgres,=r/postgres}<br /> table_privileges | {postgres=arwdRxt/postgres,=r/postgres}<br /> tables | {postgres=arwdRxt/postgres,=r/postgres}<br /> tasklog |<br /> triggered_update_columns | {postgres=arwdRxt/postgres,=r/postgres}<br /> triggers | {postgres=arwdRxt/postgres,=r/postgres}<br /> usage_privileges | {postgres=arwdRxt/postgres,=r/postgres}<br /> view_column_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> view_table_usage | {postgres=arwdRxt/postgres,=r/postgres}<br /> views | {postgres=arwdRxt/postgres,=r/postgres}<br /> (42 rows)<br /> postgres=#<br /> postgres=#<br /> postgres=#<br /> <br /> &lt;/source&gt;</div>

Admin