Checking user permissions : User Permission « View « PostgreSQL






Checking user permissions

postgres=#
postgres=# -- Checking user permissions
postgres=#
postgres=# SELECT relname as "Relation", relacl as "Access permissions"
postgres-#         FROM pg_class
postgres-#         WHERE  relkind IN ('r', 'v', 'S')
postgres-#         AND relname !~ '^pg_'
postgres-#         ORDER BY relname;
            Relation             |           Access permissions
---------------------------------+-----------------------------------------
 applicable_roles                | {postgres=arwdRxt/postgres,=r/postgres}
 check_constraints               | {postgres=arwdRxt/postgres,=r/postgres}
 column_domain_usage             | {postgres=arwdRxt/postgres,=r/postgres}
 column_privileges               | {postgres=arwdRxt/postgres,=r/postgres}
 column_udt_usage                | {postgres=arwdRxt/postgres,=r/postgres}
 columns                         | {postgres=arwdRxt/postgres,=r/postgres}
 constraint_column_usage         | {postgres=arwdRxt/postgres,=r/postgres}
 constraint_table_usage          | {postgres=arwdRxt/postgres,=r/postgres}
 data_type_privileges            | {postgres=arwdRxt/postgres,=r/postgres}
 domain_constraints              | {postgres=arwdRxt/postgres,=r/postgres}
 domain_udt_usage                | {postgres=arwdRxt/postgres,=r/postgres}
 domains                         | {postgres=arwdRxt/postgres,=r/postgres}
 element_types                   | {postgres=arwdRxt/postgres,=r/postgres}
 enabled_roles                   | {postgres=arwdRxt/postgres,=r/postgres}
 information_schema_catalog_name | {postgres=arwdRxt/postgres,=r/postgres}
 key_column_usage                | {postgres=arwdRxt/postgres,=r/postgres}
 parameters                      | {postgres=arwdRxt/postgres,=r/postgres}
 referential_constraints         | {postgres=arwdRxt/postgres,=r/postgres}
 role_column_grants              | {postgres=arwdRxt/postgres,=r/postgres}
 role_routine_grants             | {postgres=arwdRxt/postgres,=r/postgres}
 role_table_grants               | {postgres=arwdRxt/postgres,=r/postgres}
 role_usage_grants               | {postgres=arwdRxt/postgres,=r/postgres}
 routine_privileges              | {postgres=arwdRxt/postgres,=r/postgres}
 routines                        | {postgres=arwdRxt/postgres,=r/postgres}
 schemata                        | {postgres=arwdRxt/postgres,=r/postgres}
 sql_features                    | {postgres=arwdRxt/postgres,=r/postgres}
 sql_implementation_info         | {postgres=arwdRxt/postgres,=r/postgres}
 sql_languages                   | {postgres=arwdRxt/postgres,=r/postgres}
 sql_packages                    | {postgres=arwdRxt/postgres,=r/postgres}
 sql_sizing                      | {postgres=arwdRxt/postgres,=r/postgres}
 sql_sizing_profiles             | {postgres=arwdRxt/postgres,=r/postgres}
 subjects                        |
 table_constraints               | {postgres=arwdRxt/postgres,=r/postgres}
 table_privileges                | {postgres=arwdRxt/postgres,=r/postgres}
 tables                          | {postgres=arwdRxt/postgres,=r/postgres}
 tasklog                         |
 triggered_update_columns        | {postgres=arwdRxt/postgres,=r/postgres}
 triggers                        | {postgres=arwdRxt/postgres,=r/postgres}
 usage_privileges                | {postgres=arwdRxt/postgres,=r/postgres}
 view_column_usage               | {postgres=arwdRxt/postgres,=r/postgres}
 view_table_usage                | {postgres=arwdRxt/postgres,=r/postgres}
 views                           | {postgres=arwdRxt/postgres,=r/postgres}
(42 rows)

postgres=#
postgres=#
postgres=#

           
       








Related examples in the same category