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