Notes of a Systems Administrator


[root foreman]# sudo -u postgres psql
psql (8.4.20)
Type "help" for help.

postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 foreman  |    16384 | f           | f        | f         | ******** |          |
 postgres |       10 | t           | t        | t         | ******** |          |
 root     |    18564 | f           | t        | t         | ******** |          |
(3 rows)
[root ~]# psql -U root foreman -W
Password for user root:
psql (8.4.20)
Type "help" for help.

foreman=# \z
                                            Access privileges
 Schema |               Name                |   Type   |  Access privileges   | Column access privileges
--------+-----------------------------------+----------+----------------------+--------------------------
 public | architectures                     | table    |                      |
 public | architectures_id_seq              | sequence |                      |
 public | architectures_operatingsystems    | table    |                      |
 public | audits                            | table    |                      |
 public | audits_id_seq                     | sequence |                      |
 public | auth_sources                      | table    |                      |
 public | auth_sources_id_seq               | sequence |                      |
 public | bookmarks                         | table    |                      |
 public | bookmarks_id_seq                  | sequence |                      |
 public | cached_user_roles                 | table    |                      |
 public | cached_user_roles_id_seq          | sequence |                      |
 public | cached_usergroup_members          | table    |                      |
 public | cached_usergroup_members_id_seq   | sequence |                      |
 public | compute_attributes                | table    |                      |
 public | compute_attributes_id_seq         | sequence |                      |
 public | compute_profiles                  | table    |                      |
 public | compute_profiles_id_seq           | sequence |                      |
 public | compute_resources                 | table    |                      |
 public | compute_resources_id_seq          | sequence |                      |
 public | config_group_classes              | table    |                      |
 public | config_group_classes_id_seq       | sequence |                      |
 public | config_groups                     | table    |                      |
 public | config_groups_id_seq              | sequence |                      |
 public | config_templates                  | table    |                      |
 public | config_templates_id_seq           | sequence |                      |
 public | config_templates_operatingsystems | table    |                      |
 public | domains                           | table    |                      |
 public | domains_id_seq                    | sequence |                      |
 public | environment_classes               | table    |                      |
 public | environment_classes_id_seq        | sequence |                      |
 public | environments                      | table    |                      |
 public | environments_id_seq               | sequence |                      |
 public | external_usergroups               | table    |                      |
 public | external_usergroups_id_seq        | sequence |                      |
 public | fact_names                        | table    |                      |
 public | fact_names_id_seq                 | sequence |                      |
 public | fact_values                       | table    |                      |
 public | fact_values_id_seq                | sequence |                      |
 public | features                          | table    |                      |
 public | features_id_seq                   | sequence |                      |
 public | features_smart_proxies            | table    |                      |
 public | filterings                        | table    |                      |
 public | filterings_id_seq                 | sequence |                      |
 public | filters                           | table    |                      |
 public | filters_id_seq                    | sequence |                      |
 public | host_classes                      | table    |                      |
 public | host_classes_id_seq               | sequence |                      |
 public | host_config_groups                | table    |                      |
 public | host_config_groups_id_seq         | sequence |                      |
 public | hostgroup_classes                 | table    |                      |
 public | hostgroup_classes_id_seq          | sequence |                      |
 public | hostgroups                        | table    |                      |
 public | hostgroups_id_seq                 | sequence |                      |
 public | hosts                             | table    |                      |
 public | hosts_id_seq                      | sequence |                      |
 public | images                            | table    |                      |
 public | images_id_seq                     | sequence |                      |
 public | key_pairs                         | table    |                      |
 public | key_pairs_id_seq                  | sequence |                      |
 public | locations_organizations           | table    |                      |
 public | logs                              | table    |                      |
 public | logs_id_seq                       | sequence |                      |
 public | lookup_keys                       | table    |                      |
 public | lookup_keys_id_seq                | sequence |                      |
 public | lookup_values                     | table    |                      |
 public | lookup_values_id_seq              | sequence |                      |
 public | mail_notifications                | table    |                      |
 public | mail_notifications_id_seq         | sequence |                      |
 public | media                             | table    |                      |
 public | media_id_seq                      | sequence |                      |
 public | media_operatingsystems            | table    |                      |
 public | messages                          | table    |                      |
 public | messages_id_seq                   | sequence |                      |
 public | models                            | table    |                      |
 public | models_id_seq                     | sequence |                      |
 public | nics                              | table    |                      |
 public | nics_id_seq                       | sequence |                      |
 public | operatingsystems                  | table    |                      |
 public | operatingsystems_id_seq           | sequence |                      |
 public | operatingsystems_ptables          | table    |                      |
 public | operatingsystems_puppetclasses    | table    |                      |
 public | os_default_templates              | table    |                      |
 public | os_default_templates_id_seq       | sequence |                      |
 public | parameters                        | table    |                      |
 public | parameters_id_seq                 | sequence |                      |
 public | permissions                       | table    |                      |
 public | permissions_id_seq                | sequence |                      |
 public | ptables                           | table    |                      |
 public | ptables_id_seq                    | sequence |                      |
 public | puppetclasses                     | table    |                      |
 public | puppetclasses_id_seq              | sequence |                      |
 public | realms                            | table    |                      |
 public | realms_id_seq                     | sequence |                      |
 public | reports                           | table    |                      |
 public | reports_id_seq                    | sequence |                      |
 public | roles                             | table    |                      |
 public | roles_id_seq                      | sequence |                      |
 public | schema_migrations                 | table    |                      |
 public | sessions                          | table    |                      |
 public | sessions_id_seq                   | sequence |                      |
 public | settings                          | table    |                      |
 public | settings_id_seq                   | sequence |                      |
 public | setup_provisioners                | table    |                      |
 public | setup_provisioners_id_seq         | sequence |                      |
 public | smart_proxies                     | table    |                      |
 public | smart_proxies_id_seq              | sequence |                      |
 public | sources                           | table    |                      |
 public | sources_id_seq                    | sequence |                      |
 public | subnet_domains                    | table    |                      |
 public | subnet_domains_id_seq             | sequence |                      |
 public | subnets                           | table    |                      |
 public | subnets_id_seq                    | sequence |                      |
 public | taxable_taxonomies                | table    |                      |
 public | taxable_taxonomies_id_seq         | sequence |                      |
 public | taxonomies                        | table    |                      |
 public | taxonomies_id_seq                 | sequence |                      |
 public | template_combinations             | table    |                      |
 public | template_combinations_id_seq      | sequence |                      |
 public | template_kinds                    | table    |                      |
 public | template_kinds_id_seq             | sequence |                      |
 public | tokens                            | table    |                      |
 public | tokens_id_seq                     | sequence |                      |
 public | trend_counters                    | table    |                      |
 public | trend_counters_id_seq             | sequence |                      |
 public | trends                            | table    |                      |
 public | trends_id_seq                     | sequence |                      |
 public | user_mail_notifications           | table    | root=arwdDxt/root    |
                                                       : foreman=arwdDxt/root
 public | user_mail_notifications_id_seq    | sequence |                      |
 public | user_roles                        | table    |                      |
 public | user_roles_id_seq                 | sequence |                      |
 public | usergroup_members                 | table    |                      |
 public | usergroup_members_id_seq          | sequence |                      |
 public | usergroups                        | table    |                      |
 public | usergroups_id_seq                 | sequence |                      |
 public | users                             | table    |                      |
 public | users_id_seq                      | sequence |                      |
(136 rows)

foreman=# select usename, nspname || '.' || relname as relation,
       case relkind when 'r' then 'TABLE' when 'v' then 'VIEW' end as relation_type,
       priv
from pg_class join pg_namespace on pg_namespace.oid = pg_class.relnamespace,
     pg_user,
     (values('SELECT', 1),('INSERT', 2),('UPDATE', 3),('DELETE', 4)) privs(priv, privorder)
where relkind in ('r', 'v')
      and has_table_privilege(pg_user.usesysid, pg_class.oid, priv)
      and not (nspname ~ '^pg_' or nspname = 'information_schema')
order by 2, 1, 3, privorder;
 usename  |                 relation                 | relation_type |  priv
----------+------------------------------------------+---------------+--------
 foreman  | public.architectures                     | TABLE         | SELECT
 foreman  | public.architectures                     | TABLE         | INSERT
 foreman  | public.architectures                     | TABLE         | UPDATE
 foreman  | public.architectures                     | TABLE         | DELETE
 postgres | public.architectures                     | TABLE         | SELECT
 postgres | public.architectures                     | TABLE         | INSERT
 postgres | public.architectures                     | TABLE         | UPDATE
 postgres | public.architectures                     | TABLE         | DELETE
 root     | public.architectures                     | TABLE         | SELECT
 root     | public.architectures                     | TABLE         | INSERT
 root     | public.architectures                     | TABLE         | UPDATE
 root     | public.architectures                     | TABLE         | DELETE
 foreman  | public.architectures_operatingsystems    | TABLE         | SELECT
 foreman  | public.architectures_operatingsystems    | TABLE         | INSERT
 foreman  | public.architectures_operatingsystems    | TABLE         | UPDATE
 foreman  | public.architectures_operatingsystems    | TABLE         | DELETE
 postgres | public.architectures_operatingsystems    | TABLE         | SELECT
 postgres | public.architectures_operatingsystems    | TABLE         | INSERT
 postgres | public.architectures_operatingsystems    | TABLE         | UPDATE
 postgres | public.architectures_operatingsystems    | TABLE         | DELETE
 root     | public.architectures_operatingsystems    | TABLE         | SELECT
 root     | public.architectures_operatingsystems    | TABLE         | INSERT
 root     | public.architectures_operatingsystems    | TABLE         | UPDATE
 root     | public.architectures_operatingsystems    | TABLE         | DELETE
 foreman  | public.audits                            | TABLE         | SELECT
 foreman  | public.audits                            | TABLE         | INSERT
 foreman  | public.audits                            | TABLE         | UPDATE
 foreman  | public.audits                            | TABLE         | DELETE
 postgres | public.audits                            | TABLE         | SELECT
 postgres | public.audits                            | TABLE         | INSERT
 postgres | public.audits                            | TABLE         | UPDATE
 postgres | public.audits                            | TABLE         | DELETE
 root     | public.audits                            | TABLE         | SELECT
 root     | public.audits                            | TABLE         | INSERT
 root     | public.audits                            | TABLE         | UPDATE
 root     | public.audits                            | TABLE         | DELETE
 foreman  | public.auth_sources                      | TABLE         | SELECT
 foreman  | public.auth_sources                      | TABLE         | INSERT
 foreman  | public.auth_sources                      | TABLE         | UPDATE
 foreman  | public.auth_sources                      | TABLE         | DELETE
 postgres | public.auth_sources                      | TABLE         | SELECT
 postgres | public.auth_sources                      | TABLE         | INSERT
 postgres | public.auth_sources                      | TABLE         | UPDATE
 postgres | public.auth_sources                      | TABLE         | DELETE
 root     | public.auth_sources                      | TABLE         | SELECT
 root     | public.auth_sources                      | TABLE         | INSERT
 root     | public.auth_sources                      | TABLE         | UPDATE
 root     | public.auth_sources                      | TABLE         | DELETE
 foreman  | public.bookmarks                         | TABLE         | SELECT
 foreman  | public.bookmarks                         | TABLE         | INSERT
 foreman  | public.bookmarks                         | TABLE         | UPDATE
 foreman  | public.bookmarks                         | TABLE         | DELETE
 postgres | public.bookmarks                         | TABLE         | SELECT
 postgres | public.bookmarks                         | TABLE         | INSERT
 postgres | public.bookmarks                         | TABLE         | UPDATE
 postgres | public.bookmarks                         | TABLE         | DELETE
 root     | public.bookmarks                         | TABLE         | SELECT
 root     | public.bookmarks                         | TABLE         | INSERT
 root     | public.bookmarks                         | TABLE         | UPDATE
 root     | public.bookmarks                         | TABLE         | DELETE
 foreman  | public.cached_usergroup_members          | TABLE         | SELECT
 foreman  | public.cached_usergroup_members          | TABLE         | INSERT
 foreman  | public.cached_usergroup_members          | TABLE         | UPDATE
 foreman  | public.cached_usergroup_members          | TABLE         | DELETE
 postgres | public.cached_usergroup_members          | TABLE         | SELECT
 postgres | public.cached_usergroup_members          | TABLE         | INSERT
 postgres | public.cached_usergroup_members          | TABLE         | UPDATE
 postgres | public.cached_usergroup_members          | TABLE         | DELETE
 root     | public.cached_usergroup_members          | TABLE         | SELECT
 root     | public.cached_usergroup_members          | TABLE         | INSERT
 root     | public.cached_usergroup_members          | TABLE         | UPDATE
 root     | public.cached_usergroup_members          | TABLE         | DELETE
 foreman  | public.cached_user_roles                 | TABLE         | SELECT
 foreman  | public.cached_user_roles                 | TABLE         | INSERT
 foreman  | public.cached_user_roles                 | TABLE         | UPDATE
 foreman  | public.cached_user_roles                 | TABLE         | DELETE
 postgres | public.cached_user_roles                 | TABLE         | SELECT
 postgres | public.cached_user_roles                 | TABLE         | INSERT
 postgres | public.cached_user_roles                 | TABLE         | UPDATE
 postgres | public.cached_user_roles                 | TABLE         | DELETE
 root     | public.cached_user_roles                 | TABLE         | SELECT
 root     | public.cached_user_roles                 | TABLE         | INSERT
 root     | public.cached_user_roles                 | TABLE         | UPDATE
 root     | public.cached_user_roles                 | TABLE         | DELETE
 foreman  | public.compute_attributes                | TABLE         | SELECT
 foreman  | public.compute_attributes                | TABLE         | INSERT
 foreman  | public.compute_attributes                | TABLE         | UPDATE
 foreman  | public.compute_attributes                | TABLE         | DELETE
 postgres | public.compute_attributes                | TABLE         | SELECT
 postgres | public.compute_attributes                | TABLE         | INSERT
 postgres | public.compute_attributes                | TABLE         | UPDATE
 postgres | public.compute_attributes                | TABLE         | DELETE
 root     | public.compute_attributes                | TABLE         | SELECT
 root     | public.compute_attributes                | TABLE         | INSERT
 root     | public.compute_attributes                | TABLE         | UPDATE
 root     | public.compute_attributes                | TABLE         | DELETE
 foreman  | public.compute_profiles                  | TABLE         | SELECT
 foreman  | public.compute_profiles                  | TABLE         | INSERT
 foreman  | public.compute_profiles                  | TABLE         | UPDATE
 foreman  | public.compute_profiles                  | TABLE         | DELETE
 postgres | public.compute_profiles                  | TABLE         | SELECT
 postgres | public.compute_profiles                  | TABLE         | INSERT
 postgres | public.compute_profiles                  | TABLE         | UPDATE
 postgres | public.compute_profiles                  | TABLE         | DELETE
 root     | public.compute_profiles                  | TABLE         | SELECT
 root     | public.compute_profiles                  | TABLE         | INSERT
 root     | public.compute_profiles                  | TABLE         | UPDATE
 root     | public.compute_profiles                  | TABLE         | DELETE
 foreman  | public.compute_resources                 | TABLE         | SELECT
 foreman  | public.compute_resources                 | TABLE         | INSERT
 foreman  | public.compute_resources                 | TABLE         | UPDATE
 foreman  | public.compute_resources                 | TABLE         | DELETE
 postgres | public.compute_resources                 | TABLE         | SELECT
 postgres | public.compute_resources                 | TABLE         | INSERT
 postgres | public.compute_resources                 | TABLE         | UPDATE
 postgres | public.compute_resources                 | TABLE         | DELETE
 root     | public.compute_resources                 | TABLE         | SELECT
 root     | public.compute_resources                 | TABLE         | INSERT
 root     | public.compute_resources                 | TABLE         | UPDATE
 root     | public.compute_resources                 | TABLE         | DELETE
 foreman  | public.config_group_classes              | TABLE         | SELECT
 foreman  | public.config_group_classes              | TABLE         | INSERT
 foreman  | public.config_group_classes              | TABLE         | UPDATE
 foreman  | public.config_group_classes              | TABLE         | DELETE
 postgres | public.config_group_classes              | TABLE         | SELECT
 postgres | public.config_group_classes              | TABLE         | INSERT
 postgres | public.config_group_classes              | TABLE         | UPDATE
 postgres | public.config_group_classes              | TABLE         | DELETE
 root     | public.config_group_classes              | TABLE         | SELECT
 root     | public.config_group_classes              | TABLE         | INSERT
 root     | public.config_group_classes              | TABLE         | UPDATE
 root     | public.config_group_classes              | TABLE         | DELETE
 foreman  | public.config_groups                     | TABLE         | SELECT
 foreman  | public.config_groups                     | TABLE         | INSERT
 foreman  | public.config_groups                     | TABLE         | UPDATE
 foreman  | public.config_groups                     | TABLE         | DELETE
 postgres | public.config_groups                     | TABLE         | SELECT
 postgres | public.config_groups                     | TABLE         | INSERT
 postgres | public.config_groups                     | TABLE         | UPDATE
 postgres | public.config_groups                     | TABLE         | DELETE
 root     | public.config_groups                     | TABLE         | SELECT
 root     | public.config_groups                     | TABLE         | INSERT
 root     | public.config_groups                     | TABLE         | UPDATE
 root     | public.config_groups                     | TABLE         | DELETE
 foreman  | public.config_templates                  | TABLE         | SELECT
 foreman  | public.config_templates                  | TABLE         | INSERT
 foreman  | public.config_templates                  | TABLE         | UPDATE
 foreman  | public.config_templates                  | TABLE         | DELETE
 postgres | public.config_templates                  | TABLE         | SELECT
 postgres | public.config_templates                  | TABLE         | INSERT
 postgres | public.config_templates                  | TABLE         | UPDATE
 postgres | public.config_templates                  | TABLE         | DELETE
 root     | public.config_templates                  | TABLE         | SELECT
 root     | public.config_templates                  | TABLE         | INSERT
 root     | public.config_templates                  | TABLE         | UPDATE
 root     | public.config_templates                  | TABLE         | DELETE
 foreman  | public.config_templates_operatingsystems | TABLE         | SELECT
 foreman  | public.config_templates_operatingsystems | TABLE         | INSERT
 foreman  | public.config_templates_operatingsystems | TABLE         | UPDATE
 foreman  | public.config_templates_operatingsystems | TABLE         | DELETE
 postgres | public.config_templates_operatingsystems | TABLE         | SELECT
 postgres | public.config_templates_operatingsystems | TABLE         | INSERT
 postgres | public.config_templates_operatingsystems | TABLE         | UPDATE
 postgres | public.config_templates_operatingsystems | TABLE         | DELETE
 root     | public.config_templates_operatingsystems | TABLE         | SELECT
 root     | public.config_templates_operatingsystems | TABLE         | INSERT
 root     | public.config_templates_operatingsystems | TABLE         | UPDATE
 root     | public.config_templates_operatingsystems | TABLE         | DELETE
 foreman  | public.domains                           | TABLE         | SELECT
 foreman  | public.domains                           | TABLE         | INSERT
 foreman  | public.domains                           | TABLE         | UPDATE
 foreman  | public.domains                           | TABLE         | DELETE
 postgres | public.domains                           | TABLE         | SELECT
 postgres | public.domains                           | TABLE         | INSERT
 postgres | public.domains                           | TABLE         | UPDATE
 postgres | public.domains                           | TABLE         | DELETE
 root     | public.domains                           | TABLE         | SELECT
 root     | public.domains                           | TABLE         | INSERT
 root     | public.domains                           | TABLE         | UPDATE
 root     | public.domains                           | TABLE         | DELETE
 foreman  | public.environment_classes               | TABLE         | SELECT
 foreman  | public.environment_classes               | TABLE         | INSERT
 foreman  | public.environment_classes               | TABLE         | UPDATE
 foreman  | public.environment_classes               | TABLE         | DELETE
 postgres | public.environment_classes               | TABLE         | SELECT
 postgres | public.environment_classes               | TABLE         | INSERT
 postgres | public.environment_classes               | TABLE         | UPDATE
 postgres | public.environment_classes               | TABLE         | DELETE
 root     | public.environment_classes               | TABLE         | SELECT
 root     | public.environment_classes               | TABLE         | INSERT
 root     | public.environment_classes               | TABLE         | UPDATE
 root     | public.environment_classes               | TABLE         | DELETE
 foreman  | public.environments                      | TABLE         | SELECT
 foreman  | public.environments                      | TABLE         | INSERT
 foreman  | public.environments                      | TABLE         | UPDATE
 foreman  | public.environments                      | TABLE         | DELETE
 postgres | public.environments                      | TABLE         | SELECT
 postgres | public.environments                      | TABLE         | INSERT
 postgres | public.environments                      | TABLE         | UPDATE
 postgres | public.environments                      | TABLE         | DELETE
 root     | public.environments                      | TABLE         | SELECT
 root     | public.environments                      | TABLE         | INSERT
 root     | public.environments                      | TABLE         | UPDATE
 root     | public.environments                      | TABLE         | DELETE
 foreman  | public.external_usergroups               | TABLE         | SELECT
 foreman  | public.external_usergroups               | TABLE         | INSERT
 foreman  | public.external_usergroups               | TABLE         | UPDATE
 foreman  | public.external_usergroups               | TABLE         | DELETE
 postgres | public.external_usergroups               | TABLE         | SELECT
 postgres | public.external_usergroups               | TABLE         | INSERT
 postgres | public.external_usergroups               | TABLE         | UPDATE
 postgres | public.external_usergroups               | TABLE         | DELETE
 root     | public.external_usergroups               | TABLE         | SELECT
 root     | public.external_usergroups               | TABLE         | INSERT
 root     | public.external_usergroups               | TABLE         | UPDATE
 root     | public.external_usergroups               | TABLE         | DELETE
 foreman  | public.fact_names                        | TABLE         | SELECT
 foreman  | public.fact_names                        | TABLE         | INSERT
 foreman  | public.fact_names                        | TABLE         | UPDATE
 foreman  | public.fact_names                        | TABLE         | DELETE
 postgres | public.fact_names                        | TABLE         | SELECT
 postgres | public.fact_names                        | TABLE         | INSERT
 postgres | public.fact_names                        | TABLE         | UPDATE
 postgres | public.fact_names                        | TABLE         | DELETE
 root     | public.fact_names                        | TABLE         | SELECT
 root     | public.fact_names                        | TABLE         | INSERT
 root     | public.fact_names                        | TABLE         | UPDATE
 root     | public.fact_names                        | TABLE         | DELETE
 foreman  | public.fact_values                       | TABLE         | SELECT
 foreman  | public.fact_values                       | TABLE         | INSERT
 foreman  | public.fact_values                       | TABLE         | UPDATE
 foreman  | public.fact_values                       | TABLE         | DELETE
 postgres | public.fact_values                       | TABLE         | SELECT
 postgres | public.fact_values                       | TABLE         | INSERT
 postgres | public.fact_values                       | TABLE         | UPDATE
 postgres | public.fact_values                       | TABLE         | DELETE
 root     | public.fact_values                       | TABLE         | SELECT
 root     | public.fact_values                       | TABLE         | INSERT
 root     | public.fact_values                       | TABLE         | UPDATE
 root     | public.fact_values                       | TABLE         | DELETE
 foreman  | public.features                          | TABLE         | SELECT
 foreman  | public.features                          | TABLE         | INSERT
 foreman  | public.features                          | TABLE         | UPDATE
 foreman  | public.features                          | TABLE         | DELETE
 postgres | public.features                          | TABLE         | SELECT
 postgres | public.features                          | TABLE         | INSERT
 postgres | public.features                          | TABLE         | UPDATE
 postgres | public.features                          | TABLE         | DELETE
 root     | public.features                          | TABLE         | SELECT
 root     | public.features                          | TABLE         | INSERT
 root     | public.features                          | TABLE         | UPDATE
 root     | public.features                          | TABLE         | DELETE
 foreman  | public.features_smart_proxies            | TABLE         | SELECT
 foreman  | public.features_smart_proxies            | TABLE         | INSERT
 foreman  | public.features_smart_proxies            | TABLE         | UPDATE
 foreman  | public.features_smart_proxies            | TABLE         | DELETE
 postgres | public.features_smart_proxies            | TABLE         | SELECT
 postgres | public.features_smart_proxies            | TABLE         | INSERT
 postgres | public.features_smart_proxies            | TABLE         | UPDATE
 postgres | public.features_smart_proxies            | TABLE         | DELETE
 root     | public.features_smart_proxies            | TABLE         | SELECT
 root     | public.features_smart_proxies            | TABLE         | INSERT
 root     | public.features_smart_proxies            | TABLE         | UPDATE
 root     | public.features_smart_proxies            | TABLE         | DELETE
 foreman  | public.filterings                        | TABLE         | SELECT
 foreman  | public.filterings                        | TABLE         | INSERT
 foreman  | public.filterings                        | TABLE         | UPDATE
 foreman  | public.filterings                        | TABLE         | DELETE
 postgres | public.filterings                        | TABLE         | SELECT
 postgres | public.filterings                        | TABLE         | INSERT
 postgres | public.filterings                        | TABLE         | UPDATE
 postgres | public.filterings                        | TABLE         | DELETE
 root     | public.filterings                        | TABLE         | SELECT
 root     | public.filterings                        | TABLE         | INSERT
 root     | public.filterings                        | TABLE         | UPDATE
 root     | public.filterings                        | TABLE         | DELETE
 foreman  | public.filters                           | TABLE         | SELECT
 foreman  | public.filters                           | TABLE         | INSERT
 foreman  | public.filters                           | TABLE         | UPDATE
 foreman  | public.filters                           | TABLE         | DELETE
 postgres | public.filters                           | TABLE         | SELECT
 postgres | public.filters                           | TABLE         | INSERT
 postgres | public.filters                           | TABLE         | UPDATE
 postgres | public.filters                           | TABLE         | DELETE
 root     | public.filters                           | TABLE         | SELECT
 root     | public.filters                           | TABLE         | INSERT
 root     | public.filters                           | TABLE         | UPDATE
 root     | public.filters                           | TABLE         | DELETE
 foreman  | public.host_classes                      | TABLE         | SELECT
 foreman  | public.host_classes                      | TABLE         | INSERT
 foreman  | public.host_classes                      | TABLE         | UPDATE
 foreman  | public.host_classes                      | TABLE         | DELETE
 postgres | public.host_classes                      | TABLE         | SELECT
 postgres | public.host_classes                      | TABLE         | INSERT
 postgres | public.host_classes                      | TABLE         | UPDATE
 postgres | public.host_classes                      | TABLE         | DELETE
 root     | public.host_classes                      | TABLE         | SELECT
 root     | public.host_classes                      | TABLE         | INSERT
 root     | public.host_classes                      | TABLE         | UPDATE
 root     | public.host_classes                      | TABLE         | DELETE
 foreman  | public.host_config_groups                | TABLE         | SELECT
 foreman  | public.host_config_groups                | TABLE         | INSERT
 foreman  | public.host_config_groups                | TABLE         | UPDATE
 foreman  | public.host_config_groups                | TABLE         | DELETE
 postgres | public.host_config_groups                | TABLE         | SELECT
 postgres | public.host_config_groups                | TABLE         | INSERT
 postgres | public.host_config_groups                | TABLE         | UPDATE
 postgres | public.host_config_groups                | TABLE         | DELETE
 root     | public.host_config_groups                | TABLE         | SELECT
 root     | public.host_config_groups                | TABLE         | INSERT
 root     | public.host_config_groups                | TABLE         | UPDATE
 root     | public.host_config_groups                | TABLE         | DELETE
 foreman  | public.hostgroup_classes                 | TABLE         | SELECT
 foreman  | public.hostgroup_classes                 | TABLE         | INSERT
 foreman  | public.hostgroup_classes                 | TABLE         | UPDATE
 foreman  | public.hostgroup_classes                 | TABLE         | DELETE
 postgres | public.hostgroup_classes                 | TABLE         | SELECT
 postgres | public.hostgroup_classes                 | TABLE         | INSERT
 postgres | public.hostgroup_classes                 | TABLE         | UPDATE
 postgres | public.hostgroup_classes                 | TABLE         | DELETE
 root     | public.hostgroup_classes                 | TABLE         | SELECT
 root     | public.hostgroup_classes                 | TABLE         | INSERT
 root     | public.hostgroup_classes                 | TABLE         | UPDATE
 root     | public.hostgroup_classes                 | TABLE         | DELETE
 foreman  | public.hostgroups                        | TABLE         | SELECT
 foreman  | public.hostgroups                        | TABLE         | INSERT
 foreman  | public.hostgroups                        | TABLE         | UPDATE
 foreman  | public.hostgroups                        | TABLE         | DELETE
 postgres | public.hostgroups                        | TABLE         | SELECT
 postgres | public.hostgroups                        | TABLE         | INSERT
 postgres | public.hostgroups                        | TABLE         | UPDATE
 postgres | public.hostgroups                        | TABLE         | DELETE
 root     | public.hostgroups                        | TABLE         | SELECT
 root     | public.hostgroups                        | TABLE         | INSERT
 root     | public.hostgroups                        | TABLE         | UPDATE
 root     | public.hostgroups                        | TABLE         | DELETE
 foreman  | public.hosts                             | TABLE         | SELECT
 foreman  | public.hosts                             | TABLE         | INSERT
 foreman  | public.hosts                             | TABLE         | UPDATE
 foreman  | public.hosts                             | TABLE         | DELETE
 postgres | public.hosts                             | TABLE         | SELECT
 postgres | public.hosts                             | TABLE         | INSERT
 postgres | public.hosts                             | TABLE         | UPDATE
 postgres | public.hosts                             | TABLE         | DELETE
 root     | public.hosts                             | TABLE         | SELECT
 root     | public.hosts                             | TABLE         | INSERT
 root     | public.hosts                             | TABLE         | UPDATE
 root     | public.hosts                             | TABLE         | DELETE
 foreman  | public.images                            | TABLE         | SELECT
 foreman  | public.images                            | TABLE         | INSERT
 foreman  | public.images                            | TABLE         | UPDATE
 foreman  | public.images                            | TABLE         | DELETE
 postgres | public.images                            | TABLE         | SELECT
 postgres | public.images                            | TABLE         | INSERT
 postgres | public.images                            | TABLE         | UPDATE
 postgres | public.images                            | TABLE         | DELETE
 root     | public.images                            | TABLE         | SELECT
 root     | public.images                            | TABLE         | INSERT
 root     | public.images                            | TABLE         | UPDATE
 root     | public.images                            | TABLE         | DELETE
 foreman  | public.key_pairs                         | TABLE         | SELECT
 foreman  | public.key_pairs                         | TABLE         | INSERT
 foreman  | public.key_pairs                         | TABLE         | UPDATE
 foreman  | public.key_pairs                         | TABLE         | DELETE
 postgres | public.key_pairs                         | TABLE         | SELECT
 postgres | public.key_pairs                         | TABLE         | INSERT
 postgres | public.key_pairs                         | TABLE         | UPDATE
 postgres | public.key_pairs                         | TABLE         | DELETE
 root     | public.key_pairs                         | TABLE         | SELECT
 root     | public.key_pairs                         | TABLE         | INSERT
 root     | public.key_pairs                         | TABLE         | UPDATE
 root     | public.key_pairs                         | TABLE         | DELETE
 foreman  | public.locations_organizations           | TABLE         | SELECT
 foreman  | public.locations_organizations           | TABLE         | INSERT
 foreman  | public.locations_organizations           | TABLE         | UPDATE
 foreman  | public.locations_organizations           | TABLE         | DELETE
 postgres | public.locations_organizations           | TABLE         | SELECT
 postgres | public.locations_organizations           | TABLE         | INSERT
 postgres | public.locations_organizations           | TABLE         | UPDATE
 postgres | public.locations_organizations           | TABLE         | DELETE
 root     | public.locations_organizations           | TABLE         | SELECT
 root     | public.locations_organizations           | TABLE         | INSERT
 root     | public.locations_organizations           | TABLE         | UPDATE
 root     | public.locations_organizations           | TABLE         | DELETE
 foreman  | public.logs                              | TABLE         | SELECT
 foreman  | public.logs                              | TABLE         | INSERT
 foreman  | public.logs                              | TABLE         | UPDATE
 foreman  | public.logs                              | TABLE         | DELETE
 postgres | public.logs                              | TABLE         | SELECT
 postgres | public.logs                              | TABLE         | INSERT
 postgres | public.logs                              | TABLE         | UPDATE
 postgres | public.logs                              | TABLE         | DELETE
 root     | public.logs                              | TABLE         | SELECT
 root     | public.logs                              | TABLE         | INSERT
 root     | public.logs                              | TABLE         | UPDATE
 root     | public.logs                              | TABLE         | DELETE
 foreman  | public.lookup_keys                       | TABLE         | SELECT
 foreman  | public.lookup_keys                       | TABLE         | INSERT
 foreman  | public.lookup_keys                       | TABLE         | UPDATE
 foreman  | public.lookup_keys                       | TABLE         | DELETE
 postgres | public.lookup_keys                       | TABLE         | SELECT
 postgres | public.lookup_keys                       | TABLE         | INSERT
 postgres | public.lookup_keys                       | TABLE         | UPDATE
 postgres | public.lookup_keys                       | TABLE         | DELETE
 root     | public.lookup_keys                       | TABLE         | SELECT
 root     | public.lookup_keys                       | TABLE         | INSERT
 root     | public.lookup_keys                       | TABLE         | UPDATE
 root     | public.lookup_keys                       | TABLE         | DELETE
 foreman  | public.lookup_values                     | TABLE         | SELECT
 foreman  | public.lookup_values                     | TABLE         | INSERT
 foreman  | public.lookup_values                     | TABLE         | UPDATE
 foreman  | public.lookup_values                     | TABLE         | DELETE
 postgres | public.lookup_values                     | TABLE         | SELECT
 postgres | public.lookup_values                     | TABLE         | INSERT
 postgres | public.lookup_values                     | TABLE         | UPDATE
 postgres | public.lookup_values                     | TABLE         | DELETE
 root     | public.lookup_values                     | TABLE         | SELECT
 root     | public.lookup_values                     | TABLE         | INSERT
 root     | public.lookup_values                     | TABLE         | UPDATE
 root     | public.lookup_values                     | TABLE         | DELETE
 postgres | public.mail_notifications                | TABLE         | SELECT
 postgres | public.mail_notifications                | TABLE         | INSERT
 postgres | public.mail_notifications                | TABLE         | UPDATE
 postgres | public.mail_notifications                | TABLE         | DELETE
 root     | public.mail_notifications                | TABLE         | SELECT
 root     | public.mail_notifications                | TABLE         | INSERT
 root     | public.mail_notifications                | TABLE         | UPDATE
 root     | public.mail_notifications                | TABLE         | DELETE
 foreman  | public.media                             | TABLE         | SELECT
 foreman  | public.media                             | TABLE         | INSERT
 foreman  | public.media                             | TABLE         | UPDATE
 foreman  | public.media                             | TABLE         | DELETE
 postgres | public.media                             | TABLE         | SELECT
 postgres | public.media                             | TABLE         | INSERT
 postgres | public.media                             | TABLE         | UPDATE
 postgres | public.media                             | TABLE         | DELETE
 root     | public.media                             | TABLE         | SELECT
 root     | public.media                             | TABLE         | INSERT
 root     | public.media                             | TABLE         | UPDATE
 root     | public.media                             | TABLE         | DELETE
 foreman  | public.media_operatingsystems            | TABLE         | SELECT
 foreman  | public.media_operatingsystems            | TABLE         | INSERT
 foreman  | public.media_operatingsystems            | TABLE         | UPDATE
 foreman  | public.media_operatingsystems            | TABLE         | DELETE
 postgres | public.media_operatingsystems            | TABLE         | SELECT
 postgres | public.media_operatingsystems            | TABLE         | INSERT
 postgres | public.media_operatingsystems            | TABLE         | UPDATE
 postgres | public.media_operatingsystems            | TABLE         | DELETE
 root     | public.media_operatingsystems            | TABLE         | SELECT
 root     | public.media_operatingsystems            | TABLE         | INSERT
 root     | public.media_operatingsystems            | TABLE         | UPDATE
 root     | public.media_operatingsystems            | TABLE         | DELETE
 foreman  | public.messages                          | TABLE         | SELECT
 foreman  | public.messages                          | TABLE         | INSERT
 foreman  | public.messages                          | TABLE         | UPDATE
 foreman  | public.messages                          | TABLE         | DELETE
 postgres | public.messages                          | TABLE         | SELECT
 postgres | public.messages                          | TABLE         | INSERT
 postgres | public.messages                          | TABLE         | UPDATE
 postgres | public.messages                          | TABLE         | DELETE
 root     | public.messages                          | TABLE         | SELECT
 root     | public.messages                          | TABLE         | INSERT
 root     | public.messages                          | TABLE         | UPDATE
 root     | public.messages                          | TABLE         | DELETE
 foreman  | public.models                            | TABLE         | SELECT
 foreman  | public.models                            | TABLE         | INSERT
 foreman  | public.models                            | TABLE         | UPDATE
 foreman  | public.models                            | TABLE         | DELETE
 postgres | public.models                            | TABLE         | SELECT
 postgres | public.models                            | TABLE         | INSERT
 postgres | public.models                            | TABLE         | UPDATE
 postgres | public.models                            | TABLE         | DELETE
 root     | public.models                            | TABLE         | SELECT
 root     | public.models                            | TABLE         | INSERT
 root     | public.models                            | TABLE         | UPDATE
 root     | public.models                            | TABLE         | DELETE
 foreman  | public.nics                              | TABLE         | SELECT
 foreman  | public.nics                              | TABLE         | INSERT
 foreman  | public.nics                              | TABLE         | UPDATE
 foreman  | public.nics                              | TABLE         | DELETE
 postgres | public.nics                              | TABLE         | SELECT
 postgres | public.nics                              | TABLE         | INSERT
 postgres | public.nics                              | TABLE         | UPDATE
 postgres | public.nics                              | TABLE         | DELETE
 root     | public.nics                              | TABLE         | SELECT
 root     | public.nics                              | TABLE         | INSERT
 root     | public.nics                              | TABLE         | UPDATE
 root     | public.nics                              | TABLE         | DELETE
 foreman  | public.operatingsystems                  | TABLE         | SELECT
 foreman  | public.operatingsystems                  | TABLE         | INSERT
 foreman  | public.operatingsystems                  | TABLE         | UPDATE
 foreman  | public.operatingsystems                  | TABLE         | DELETE
 postgres | public.operatingsystems                  | TABLE         | SELECT
 postgres | public.operatingsystems                  | TABLE         | INSERT
 postgres | public.operatingsystems                  | TABLE         | UPDATE
 postgres | public.operatingsystems                  | TABLE         | DELETE
 root     | public.operatingsystems                  | TABLE         | SELECT
 root     | public.operatingsystems                  | TABLE         | INSERT
 root     | public.operatingsystems                  | TABLE         | UPDATE
 root     | public.operatingsystems                  | TABLE         | DELETE
 foreman  | public.operatingsystems_ptables          | TABLE         | SELECT
 foreman  | public.operatingsystems_ptables          | TABLE         | INSERT
 foreman  | public.operatingsystems_ptables          | TABLE         | UPDATE
 foreman  | public.operatingsystems_ptables          | TABLE         | DELETE
 postgres | public.operatingsystems_ptables          | TABLE         | SELECT
 postgres | public.operatingsystems_ptables          | TABLE         | INSERT
 postgres | public.operatingsystems_ptables          | TABLE         | UPDATE
 postgres | public.operatingsystems_ptables          | TABLE         | DELETE
 root     | public.operatingsystems_ptables          | TABLE         | SELECT
 root     | public.operatingsystems_ptables          | TABLE         | INSERT
 root     | public.operatingsystems_ptables          | TABLE         | UPDATE
 root     | public.operatingsystems_ptables          | TABLE         | DELETE
 foreman  | public.operatingsystems_puppetclasses    | TABLE         | SELECT
 foreman  | public.operatingsystems_puppetclasses    | TABLE         | INSERT
 foreman  | public.operatingsystems_puppetclasses    | TABLE         | UPDATE
 foreman  | public.operatingsystems_puppetclasses    | TABLE         | DELETE
 postgres | public.operatingsystems_puppetclasses    | TABLE         | SELECT
 postgres | public.operatingsystems_puppetclasses    | TABLE         | INSERT
 postgres | public.operatingsystems_puppetclasses    | TABLE         | UPDATE
 postgres | public.operatingsystems_puppetclasses    | TABLE         | DELETE
 root     | public.operatingsystems_puppetclasses    | TABLE         | SELECT
 root     | public.operatingsystems_puppetclasses    | TABLE         | INSERT
 root     | public.operatingsystems_puppetclasses    | TABLE         | UPDATE
 root     | public.operatingsystems_puppetclasses    | TABLE         | DELETE
 foreman  | public.os_default_templates              | TABLE         | SELECT
 foreman  | public.os_default_templates              | TABLE         | INSERT
 foreman  | public.os_default_templates              | TABLE         | UPDATE
 foreman  | public.os_default_templates              | TABLE         | DELETE
 postgres | public.os_default_templates              | TABLE         | SELECT
 postgres | public.os_default_templates              | TABLE         | INSERT
 postgres | public.os_default_templates              | TABLE         | UPDATE
 postgres | public.os_default_templates              | TABLE         | DELETE
 root     | public.os_default_templates              | TABLE         | SELECT
 root     | public.os_default_templates              | TABLE         | INSERT
 root     | public.os_default_templates              | TABLE         | UPDATE
 root     | public.os_default_templates              | TABLE         | DELETE
 foreman  | public.parameters                        | TABLE         | SELECT
 foreman  | public.parameters                        | TABLE         | INSERT
 foreman  | public.parameters                        | TABLE         | UPDATE
 foreman  | public.parameters                        | TABLE         | DELETE
 postgres | public.parameters                        | TABLE         | SELECT
 postgres | public.parameters                        | TABLE         | INSERT
 postgres | public.parameters                        | TABLE         | UPDATE
 postgres | public.parameters                        | TABLE         | DELETE
 root     | public.parameters                        | TABLE         | SELECT
 root     | public.parameters                        | TABLE         | INSERT
 root     | public.parameters                        | TABLE         | UPDATE
 root     | public.parameters                        | TABLE         | DELETE
 foreman  | public.permissions                       | TABLE         | SELECT
 foreman  | public.permissions                       | TABLE         | INSERT
 foreman  | public.permissions                       | TABLE         | UPDATE
 foreman  | public.permissions                       | TABLE         | DELETE
 postgres | public.permissions                       | TABLE         | SELECT
 postgres | public.permissions                       | TABLE         | INSERT
 postgres | public.permissions                       | TABLE         | UPDATE
 postgres | public.permissions                       | TABLE         | DELETE
 root     | public.permissions                       | TABLE         | SELECT
 root     | public.permissions                       | TABLE         | INSERT
 root     | public.permissions                       | TABLE         | UPDATE
 root     | public.permissions                       | TABLE         | DELETE
 foreman  | public.ptables                           | TABLE         | SELECT
 foreman  | public.ptables                           | TABLE         | INSERT
 foreman  | public.ptables                           | TABLE         | UPDATE
 foreman  | public.ptables                           | TABLE         | DELETE
 postgres | public.ptables                           | TABLE         | SELECT
 postgres | public.ptables                           | TABLE         | INSERT
 postgres | public.ptables                           | TABLE         | UPDATE
 postgres | public.ptables                           | TABLE         | DELETE
 root     | public.ptables                           | TABLE         | SELECT
 root     | public.ptables                           | TABLE         | INSERT
 root     | public.ptables                           | TABLE         | UPDATE
 root     | public.ptables                           | TABLE         | DELETE
 foreman  | public.puppetclasses                     | TABLE         | SELECT
 foreman  | public.puppetclasses                     | TABLE         | INSERT
 foreman  | public.puppetclasses                     | TABLE         | UPDATE
 foreman  | public.puppetclasses                     | TABLE         | DELETE
 postgres | public.puppetclasses                     | TABLE         | SELECT
 postgres | public.puppetclasses                     | TABLE         | INSERT
 postgres | public.puppetclasses                     | TABLE         | UPDATE
 postgres | public.puppetclasses                     | TABLE         | DELETE
 root     | public.puppetclasses                     | TABLE         | SELECT
 root     | public.puppetclasses                     | TABLE         | INSERT
 root     | public.puppetclasses                     | TABLE         | UPDATE
 root     | public.puppetclasses                     | TABLE         | DELETE
 foreman  | public.realms                            | TABLE         | SELECT
 foreman  | public.realms                            | TABLE         | INSERT
 foreman  | public.realms                            | TABLE         | UPDATE
 foreman  | public.realms                            | TABLE         | DELETE
 postgres | public.realms                            | TABLE         | SELECT
 postgres | public.realms                            | TABLE         | INSERT
 postgres | public.realms                            | TABLE         | UPDATE
 postgres | public.realms                            | TABLE         | DELETE
 root     | public.realms                            | TABLE         | SELECT
 root     | public.realms                            | TABLE         | INSERT
 root     | public.realms                            | TABLE         | UPDATE
 root     | public.realms                            | TABLE         | DELETE
 foreman  | public.reports                           | TABLE         | SELECT
 foreman  | public.reports                           | TABLE         | INSERT
 foreman  | public.reports                           | TABLE         | UPDATE
 foreman  | public.reports                           | TABLE         | DELETE
 postgres | public.reports                           | TABLE         | SELECT
 postgres | public.reports                           | TABLE         | INSERT
 postgres | public.reports                           | TABLE         | UPDATE
 postgres | public.reports                           | TABLE         | DELETE
 root     | public.reports                           | TABLE         | SELECT
 root     | public.reports                           | TABLE         | INSERT
 root     | public.reports                           | TABLE         | UPDATE
 root     | public.reports                           | TABLE         | DELETE
 foreman  | public.roles                             | TABLE         | SELECT
 foreman  | public.roles                             | TABLE         | INSERT
 foreman  | public.roles                             | TABLE         | UPDATE
 foreman  | public.roles                             | TABLE         | DELETE
 postgres | public.roles                             | TABLE         | SELECT
 postgres | public.roles                             | TABLE         | INSERT
 postgres | public.roles                             | TABLE         | UPDATE
 postgres | public.roles                             | TABLE         | DELETE
 root     | public.roles                             | TABLE         | SELECT
 root     | public.roles                             | TABLE         | INSERT
 root     | public.roles                             | TABLE         | UPDATE
 root     | public.roles                             | TABLE         | DELETE
 foreman  | public.schema_migrations                 | TABLE         | SELECT
 foreman  | public.schema_migrations                 | TABLE         | INSERT
 foreman  | public.schema_migrations                 | TABLE         | UPDATE
 foreman  | public.schema_migrations                 | TABLE         | DELETE
 postgres | public.schema_migrations                 | TABLE         | SELECT
 postgres | public.schema_migrations                 | TABLE         | INSERT
 postgres | public.schema_migrations                 | TABLE         | UPDATE
 postgres | public.schema_migrations                 | TABLE         | DELETE
 root     | public.schema_migrations                 | TABLE         | SELECT
 root     | public.schema_migrations                 | TABLE         | INSERT
 root     | public.schema_migrations                 | TABLE         | UPDATE
 root     | public.schema_migrations                 | TABLE         | DELETE
 foreman  | public.sessions                          | TABLE         | SELECT
 foreman  | public.sessions                          | TABLE         | INSERT
 foreman  | public.sessions                          | TABLE         | UPDATE
 foreman  | public.sessions                          | TABLE         | DELETE
 postgres | public.sessions                          | TABLE         | SELECT
 postgres | public.sessions                          | TABLE         | INSERT
 postgres | public.sessions                          | TABLE         | UPDATE
 postgres | public.sessions                          | TABLE         | DELETE
 root     | public.sessions                          | TABLE         | SELECT
 root     | public.sessions                          | TABLE         | INSERT
 root     | public.sessions                          | TABLE         | UPDATE
 root     | public.sessions                          | TABLE         | DELETE
 foreman  | public.settings                          | TABLE         | SELECT
 foreman  | public.settings                          | TABLE         | INSERT
 foreman  | public.settings                          | TABLE         | UPDATE
 foreman  | public.settings                          | TABLE         | DELETE
 postgres | public.settings                          | TABLE         | SELECT
 postgres | public.settings                          | TABLE         | INSERT
 postgres | public.settings                          | TABLE         | UPDATE
 postgres | public.settings                          | TABLE         | DELETE
 root     | public.settings                          | TABLE         | SELECT
 root     | public.settings                          | TABLE         | INSERT
 root     | public.settings                          | TABLE         | UPDATE
 root     | public.settings                          | TABLE         | DELETE
 foreman  | public.setup_provisioners                | TABLE         | SELECT
 foreman  | public.setup_provisioners                | TABLE         | INSERT
 foreman  | public.setup_provisioners                | TABLE         | UPDATE
 foreman  | public.setup_provisioners                | TABLE         | DELETE
 postgres | public.setup_provisioners                | TABLE         | SELECT
 postgres | public.setup_provisioners                | TABLE         | INSERT
 postgres | public.setup_provisioners                | TABLE         | UPDATE
 postgres | public.setup_provisioners                | TABLE         | DELETE
 root     | public.setup_provisioners                | TABLE         | SELECT
 root     | public.setup_provisioners                | TABLE         | INSERT
 root     | public.setup_provisioners                | TABLE         | UPDATE
 root     | public.setup_provisioners                | TABLE         | DELETE
 foreman  | public.smart_proxies                     | TABLE         | SELECT
 foreman  | public.smart_proxies                     | TABLE         | INSERT
 foreman  | public.smart_proxies                     | TABLE         | UPDATE
 foreman  | public.smart_proxies                     | TABLE         | DELETE
 postgres | public.smart_proxies                     | TABLE         | SELECT
 postgres | public.smart_proxies                     | TABLE         | INSERT
 postgres | public.smart_proxies                     | TABLE         | UPDATE
 postgres | public.smart_proxies                     | TABLE         | DELETE
 root     | public.smart_proxies                     | TABLE         | SELECT
 root     | public.smart_proxies                     | TABLE         | INSERT
 root     | public.smart_proxies                     | TABLE         | UPDATE
 root     | public.smart_proxies                     | TABLE         | DELETE
 foreman  | public.sources                           | TABLE         | SELECT
 foreman  | public.sources                           | TABLE         | INSERT
 foreman  | public.sources                           | TABLE         | UPDATE
 foreman  | public.sources                           | TABLE         | DELETE
 postgres | public.sources                           | TABLE         | SELECT
 postgres | public.sources                           | TABLE         | INSERT
 postgres | public.sources                           | TABLE         | UPDATE
 postgres | public.sources                           | TABLE         | DELETE
 root     | public.sources                           | TABLE         | SELECT
 root     | public.sources                           | TABLE         | INSERT
 root     | public.sources                           | TABLE         | UPDATE
 root     | public.sources                           | TABLE         | DELETE
 foreman  | public.subnet_domains                    | TABLE         | SELECT
 foreman  | public.subnet_domains                    | TABLE         | INSERT
 foreman  | public.subnet_domains                    | TABLE         | UPDATE
 foreman  | public.subnet_domains                    | TABLE         | DELETE
 postgres | public.subnet_domains                    | TABLE         | SELECT
 postgres | public.subnet_domains                    | TABLE         | INSERT
 postgres | public.subnet_domains                    | TABLE         | UPDATE
 postgres | public.subnet_domains                    | TABLE         | DELETE
 root     | public.subnet_domains                    | TABLE         | SELECT
 root     | public.subnet_domains                    | TABLE         | INSERT
 root     | public.subnet_domains                    | TABLE         | UPDATE
 root     | public.subnet_domains                    | TABLE         | DELETE
 foreman  | public.subnets                           | TABLE         | SELECT
 foreman  | public.subnets                           | TABLE         | INSERT
 foreman  | public.subnets                           | TABLE         | UPDATE
 foreman  | public.subnets                           | TABLE         | DELETE
 postgres | public.subnets                           | TABLE         | SELECT
 postgres | public.subnets                           | TABLE         | INSERT
 postgres | public.subnets                           | TABLE         | UPDATE
 postgres | public.subnets                           | TABLE         | DELETE
 root     | public.subnets                           | TABLE         | SELECT
 root     | public.subnets                           | TABLE         | INSERT
 root     | public.subnets                           | TABLE         | UPDATE
 root     | public.subnets                           | TABLE         | DELETE
 foreman  | public.taxable_taxonomies                | TABLE         | SELECT
 foreman  | public.taxable_taxonomies                | TABLE         | INSERT
 foreman  | public.taxable_taxonomies                | TABLE         | UPDATE
 foreman  | public.taxable_taxonomies                | TABLE         | DELETE
 postgres | public.taxable_taxonomies                | TABLE         | SELECT
 postgres | public.taxable_taxonomies                | TABLE         | INSERT
 postgres | public.taxable_taxonomies                | TABLE         | UPDATE
 postgres | public.taxable_taxonomies                | TABLE         | DELETE
 root     | public.taxable_taxonomies                | TABLE         | SELECT
 root     | public.taxable_taxonomies                | TABLE         | INSERT
 root     | public.taxable_taxonomies                | TABLE         | UPDATE
 root     | public.taxable_taxonomies                | TABLE         | DELETE
 foreman  | public.taxonomies                        | TABLE         | SELECT
 foreman  | public.taxonomies                        | TABLE         | INSERT
 foreman  | public.taxonomies                        | TABLE         | UPDATE
 foreman  | public.taxonomies                        | TABLE         | DELETE
 postgres | public.taxonomies                        | TABLE         | SELECT
 postgres | public.taxonomies                        | TABLE         | INSERT
 postgres | public.taxonomies                        | TABLE         | UPDATE
 postgres | public.taxonomies                        | TABLE         | DELETE
 root     | public.taxonomies                        | TABLE         | SELECT
 root     | public.taxonomies                        | TABLE         | INSERT
 root     | public.taxonomies                        | TABLE         | UPDATE
 root     | public.taxonomies                        | TABLE         | DELETE
 foreman  | public.template_combinations             | TABLE         | SELECT
 foreman  | public.template_combinations             | TABLE         | INSERT
 foreman  | public.template_combinations             | TABLE         | UPDATE
 foreman  | public.template_combinations             | TABLE         | DELETE
 postgres | public.template_combinations             | TABLE         | SELECT
 postgres | public.template_combinations             | TABLE         | INSERT
 postgres | public.template_combinations             | TABLE         | UPDATE
 postgres | public.template_combinations             | TABLE         | DELETE
 root     | public.template_combinations             | TABLE         | SELECT
 root     | public.template_combinations             | TABLE         | INSERT
 root     | public.template_combinations             | TABLE         | UPDATE
 root     | public.template_combinations             | TABLE         | DELETE
 foreman  | public.template_kinds                    | TABLE         | SELECT
 foreman  | public.template_kinds                    | TABLE         | INSERT
 foreman  | public.template_kinds                    | TABLE         | UPDATE
 foreman  | public.template_kinds                    | TABLE         | DELETE
 postgres | public.template_kinds                    | TABLE         | SELECT
 postgres | public.template_kinds                    | TABLE         | INSERT
 postgres | public.template_kinds                    | TABLE         | UPDATE
 postgres | public.template_kinds                    | TABLE         | DELETE
 root     | public.template_kinds                    | TABLE         | SELECT
 root     | public.template_kinds                    | TABLE         | INSERT
 root     | public.template_kinds                    | TABLE         | UPDATE
 root     | public.template_kinds                    | TABLE         | DELETE
 foreman  | public.tokens                            | TABLE         | SELECT
 foreman  | public.tokens                            | TABLE         | INSERT
 foreman  | public.tokens                            | TABLE         | UPDATE
 foreman  | public.tokens                            | TABLE         | DELETE
 postgres | public.tokens                            | TABLE         | SELECT
 postgres | public.tokens                            | TABLE         | INSERT
 postgres | public.tokens                            | TABLE         | UPDATE
 postgres | public.tokens                            | TABLE         | DELETE
 root     | public.tokens                            | TABLE         | SELECT
 root     | public.tokens                            | TABLE         | INSERT
 root     | public.tokens                            | TABLE         | UPDATE
 root     | public.tokens                            | TABLE         | DELETE
 foreman  | public.trend_counters                    | TABLE         | SELECT
 foreman  | public.trend_counters                    | TABLE         | INSERT
 foreman  | public.trend_counters                    | TABLE         | UPDATE
 foreman  | public.trend_counters                    | TABLE         | DELETE
 postgres | public.trend_counters                    | TABLE         | SELECT
 postgres | public.trend_counters                    | TABLE         | INSERT
 postgres | public.trend_counters                    | TABLE         | UPDATE
 postgres | public.trend_counters                    | TABLE         | DELETE
 root     | public.trend_counters                    | TABLE         | SELECT
 root     | public.trend_counters                    | TABLE         | INSERT
 root     | public.trend_counters                    | TABLE         | UPDATE
 root     | public.trend_counters                    | TABLE         | DELETE
 foreman  | public.trends                            | TABLE         | SELECT
 foreman  | public.trends                            | TABLE         | INSERT
 foreman  | public.trends                            | TABLE         | UPDATE
 foreman  | public.trends                            | TABLE         | DELETE
 postgres | public.trends                            | TABLE         | SELECT
 postgres | public.trends                            | TABLE         | INSERT
 postgres | public.trends                            | TABLE         | UPDATE
 postgres | public.trends                            | TABLE         | DELETE
 root     | public.trends                            | TABLE         | SELECT
 root     | public.trends                            | TABLE         | INSERT
 root     | public.trends                            | TABLE         | UPDATE
 root     | public.trends                            | TABLE         | DELETE
 foreman  | public.usergroup_members                 | TABLE         | SELECT
 foreman  | public.usergroup_members                 | TABLE         | INSERT
 foreman  | public.usergroup_members                 | TABLE         | UPDATE
 foreman  | public.usergroup_members                 | TABLE         | DELETE
 postgres | public.usergroup_members                 | TABLE         | SELECT
 postgres | public.usergroup_members                 | TABLE         | INSERT
 postgres | public.usergroup_members                 | TABLE         | UPDATE
 postgres | public.usergroup_members                 | TABLE         | DELETE
 root     | public.usergroup_members                 | TABLE         | SELECT
 root     | public.usergroup_members                 | TABLE         | INSERT
 root     | public.usergroup_members                 | TABLE         | UPDATE
 root     | public.usergroup_members                 | TABLE         | DELETE
 foreman  | public.usergroups                        | TABLE         | SELECT
 foreman  | public.usergroups                        | TABLE         | INSERT
 foreman  | public.usergroups                        | TABLE         | UPDATE
 foreman  | public.usergroups                        | TABLE         | DELETE
 postgres | public.usergroups                        | TABLE         | SELECT
 postgres | public.usergroups                        | TABLE         | INSERT
 postgres | public.usergroups                        | TABLE         | UPDATE
 postgres | public.usergroups                        | TABLE         | DELETE
 root     | public.usergroups                        | TABLE         | SELECT
 root     | public.usergroups                        | TABLE         | INSERT
 root     | public.usergroups                        | TABLE         | UPDATE
 root     | public.usergroups                        | TABLE         | DELETE
 foreman  | public.user_mail_notifications           | TABLE         | SELECT
 foreman  | public.user_mail_notifications           | TABLE         | INSERT
 foreman  | public.user_mail_notifications           | TABLE         | UPDATE
 foreman  | public.user_mail_notifications           | TABLE         | DELETE
 postgres | public.user_mail_notifications           | TABLE         | SELECT
 postgres | public.user_mail_notifications           | TABLE         | INSERT
 postgres | public.user_mail_notifications           | TABLE         | UPDATE
 postgres | public.user_mail_notifications           | TABLE         | DELETE
 root     | public.user_mail_notifications           | TABLE         | SELECT
 root     | public.user_mail_notifications           | TABLE         | INSERT
 root     | public.user_mail_notifications           | TABLE         | UPDATE
 root     | public.user_mail_notifications           | TABLE         | DELETE
 foreman  | public.user_roles                        | TABLE         | SELECT
 foreman  | public.user_roles                        | TABLE         | INSERT
 foreman  | public.user_roles                        | TABLE         | UPDATE
 foreman  | public.user_roles                        | TABLE         | DELETE
 postgres | public.user_roles                        | TABLE         | SELECT
 postgres | public.user_roles                        | TABLE         | INSERT
 postgres | public.user_roles                        | TABLE         | UPDATE
 postgres | public.user_roles                        | TABLE         | DELETE
 root     | public.user_roles                        | TABLE         | SELECT
 root     | public.user_roles                        | TABLE         | INSERT
 root     | public.user_roles                        | TABLE         | UPDATE
 root     | public.user_roles                        | TABLE         | DELETE
 foreman  | public.users                             | TABLE         | SELECT
 foreman  | public.users                             | TABLE         | INSERT
 foreman  | public.users                             | TABLE         | UPDATE
 foreman  | public.users                             | TABLE         | DELETE
 postgres | public.users                             | TABLE         | SELECT
 postgres | public.users                             | TABLE         | INSERT
 postgres | public.users                             | TABLE         | UPDATE
 postgres | public.users                             | TABLE         | DELETE
 root     | public.users                             | TABLE         | SELECT
 root     | public.users                             | TABLE         | INSERT
 root     | public.users                             | TABLE         | UPDATE
 root     | public.users                             | TABLE         | DELETE
(860 rows)

foreman=# \d
                        List of relations
 Schema |               Name                |   Type   |  Owner
--------+-----------------------------------+----------+---------
 public | architectures                     | table    | foreman
 public | architectures_id_seq              | sequence | foreman
 public | architectures_operatingsystems    | table    | foreman
 public | audits                            | table    | foreman
 public | audits_id_seq                     | sequence | foreman
 public | auth_sources                      | table    | foreman
 public | auth_sources_id_seq               | sequence | foreman
 public | bookmarks                         | table    | foreman
 public | bookmarks_id_seq                  | sequence | foreman
 public | cached_user_roles                 | table    | foreman
 public | cached_user_roles_id_seq          | sequence | foreman
 public | cached_usergroup_members          | table    | foreman
 public | cached_usergroup_members_id_seq   | sequence | foreman
 public | compute_attributes                | table    | foreman
 public | compute_attributes_id_seq         | sequence | foreman
 public | compute_profiles                  | table    | foreman
 public | compute_profiles_id_seq           | sequence | foreman
 public | compute_resources                 | table    | foreman
 public | compute_resources_id_seq          | sequence | foreman
 public | config_group_classes              | table    | foreman
 public | config_group_classes_id_seq       | sequence | foreman
 public | config_groups                     | table    | foreman
 public | config_groups_id_seq              | sequence | foreman
 public | config_templates                  | table    | foreman
 public | config_templates_id_seq           | sequence | foreman
 public | config_templates_operatingsystems | table    | foreman
 public | domains                           | table    | foreman
 public | domains_id_seq                    | sequence | foreman
 public | environment_classes               | table    | foreman
 public | environment_classes_id_seq        | sequence | foreman
 public | environments                      | table    | foreman
 public | environments_id_seq               | sequence | foreman
 public | external_usergroups               | table    | foreman
 public | external_usergroups_id_seq        | sequence | foreman
 public | fact_names                        | table    | foreman
 public | fact_names_id_seq                 | sequence | foreman
 public | fact_values                       | table    | foreman
 public | fact_values_id_seq                | sequence | foreman
 public | features                          | table    | foreman
 public | features_id_seq                   | sequence | foreman
 public | features_smart_proxies            | table    | foreman
 public | filterings                        | table    | foreman
 public | filterings_id_seq                 | sequence | foreman
 public | filters                           | table    | foreman
 public | filters_id_seq                    | sequence | foreman
 public | host_classes                      | table    | foreman
 public | host_classes_id_seq               | sequence | foreman
 public | host_config_groups                | table    | foreman
 public | host_config_groups_id_seq         | sequence | foreman
 public | hostgroup_classes                 | table    | foreman
 public | hostgroup_classes_id_seq          | sequence | foreman
 public | hostgroups                        | table    | foreman
 public | hostgroups_id_seq                 | sequence | foreman
 public | hosts                             | table    | foreman
 public | hosts_id_seq                      | sequence | foreman
 public | images                            | table    | foreman
 public | images_id_seq                     | sequence | foreman
 public | key_pairs                         | table    | foreman
 public | key_pairs_id_seq                  | sequence | foreman
 public | locations_organizations           | table    | foreman
 public | logs                              | table    | foreman
 public | logs_id_seq                       | sequence | foreman
 public | lookup_keys                       | table    | foreman
 public | lookup_keys_id_seq                | sequence | foreman
 public | lookup_values                     | table    | foreman
 public | lookup_values_id_seq              | sequence | foreman
 public | mail_notifications                | table    | root
 public | mail_notifications_id_seq         | sequence | root
 public | media                             | table    | foreman
 public | media_id_seq                      | sequence | foreman
 public | media_operatingsystems            | table    | foreman
 public | messages                          | table    | foreman
 public | messages_id_seq                   | sequence | foreman
 public | models                            | table    | foreman
 public | models_id_seq                     | sequence | foreman
 public | nics                              | table    | foreman
 public | nics_id_seq                       | sequence | foreman
 public | operatingsystems                  | table    | foreman
 public | operatingsystems_id_seq           | sequence | foreman
 public | operatingsystems_ptables          | table    | foreman
 public | operatingsystems_puppetclasses    | table    | foreman
 public | os_default_templates              | table    | foreman
 public | os_default_templates_id_seq       | sequence | foreman
 public | parameters                        | table    | foreman
 public | parameters_id_seq                 | sequence | foreman
 public | permissions                       | table    | foreman
 public | permissions_id_seq                | sequence | foreman
 public | ptables                           | table    | foreman
 public | ptables_id_seq                    | sequence | foreman
 public | puppetclasses                     | table    | foreman
 public | puppetclasses_id_seq              | sequence | foreman
 public | realms                            | table    | foreman
 public | realms_id_seq                     | sequence | foreman
 public | reports                           | table    | foreman
 public | reports_id_seq                    | sequence | foreman
 public | roles                             | table    | foreman
 public | roles_id_seq                      | sequence | foreman
 public | schema_migrations                 | table    | foreman
 public | sessions                          | table    | foreman
 public | sessions_id_seq                   | sequence | foreman
 public | settings                          | table    | foreman
 public | settings_id_seq                   | sequence | foreman
 public | setup_provisioners                | table    | foreman
 public | setup_provisioners_id_seq         | sequence | foreman
 public | smart_proxies                     | table    | foreman
 public | smart_proxies_id_seq              | sequence | foreman
 public | sources                           | table    | foreman
 public | sources_id_seq                    | sequence | foreman
 public | subnet_domains                    | table    | foreman
 public | subnet_domains_id_seq             | sequence | foreman
 public | subnets                           | table    | foreman
 public | subnets_id_seq                    | sequence | foreman
 public | taxable_taxonomies                | table    | foreman
 public | taxable_taxonomies_id_seq         | sequence | foreman
 public | taxonomies                        | table    | foreman
 public | taxonomies_id_seq                 | sequence | foreman
 public | template_combinations             | table    | foreman
 public | template_combinations_id_seq      | sequence | foreman
 public | template_kinds                    | table    | foreman
 public | template_kinds_id_seq             | sequence | foreman
 public | tokens                            | table    | foreman
 public | tokens_id_seq                     | sequence | foreman
 public | trend_counters                    | table    | foreman
 public | trend_counters_id_seq             | sequence | foreman
 public | trends                            | table    | foreman
 public | trends_id_seq                     | sequence | foreman
 public | user_mail_notifications           | table    | root
 public | user_mail_notifications_id_seq    | sequence | root
 public | user_roles                        | table    | foreman
 public | user_roles_id_seq                 | sequence | foreman
 public | usergroup_members                 | table    | foreman
 public | usergroup_members_id_seq          | sequence | foreman
 public | usergroups                        | table    | foreman
 public | usergroups_id_seq                 | sequence | foreman
 public | users                             | table    | foreman
 public | users_id_seq                      | sequence | foreman
(136 rows)

foreman=# \d
                        List of relations
 Schema |               Name                |   Type   |  Owner
--------+-----------------------------------+----------+---------
 public | architectures                     | table    | foreman
 public | architectures_id_seq              | sequence | foreman
 public | architectures_operatingsystems    | table    | foreman
 public | audits                            | table    | foreman
 public | audits_id_seq                     | sequence | foreman
 public | auth_sources                      | table    | foreman
 public | auth_sources_id_seq               | sequence | foreman
 public | bookmarks                         | table    | foreman
 public | bookmarks_id_seq                  | sequence | foreman
 public | cached_user_roles                 | table    | foreman
 public | cached_user_roles_id_seq          | sequence | foreman
 public | cached_usergroup_members          | table    | foreman
 public | cached_usergroup_members_id_seq   | sequence | foreman
 public | compute_attributes                | table    | foreman
 public | compute_attributes_id_seq         | sequence | foreman
 public | compute_profiles                  | table    | foreman
 public | compute_profiles_id_seq           | sequence | foreman
 public | compute_resources                 | table    | foreman
 public | compute_resources_id_seq          | sequence | foreman
 public | config_group_classes              | table    | foreman
 public | config_group_classes_id_seq       | sequence | foreman
 public | config_groups                     | table    | foreman
 public | config_groups_id_seq              | sequence | foreman
 public | config_templates                  | table    | foreman
 public | config_templates_id_seq           | sequence | foreman
 public | config_templates_operatingsystems | table    | foreman
 public | domains                           | table    | foreman
 public | domains_id_seq                    | sequence | foreman
 public | environment_classes               | table    | foreman
 public | environment_classes_id_seq        | sequence | foreman
 public | environments                      | table    | foreman
 public | environments_id_seq               | sequence | foreman
 public | external_usergroups               | table    | foreman
 public | external_usergroups_id_seq        | sequence | foreman
 public | fact_names                        | table    | foreman
 public | fact_names_id_seq                 | sequence | foreman
 public | fact_values                       | table    | foreman
 public | fact_values_id_seq                | sequence | foreman
 public | features                          | table    | foreman
 public | features_id_seq                   | sequence | foreman
 public | features_smart_proxies            | table    | foreman
 public | filterings                        | table    | foreman
 public | filterings_id_seq                 | sequence | foreman
 public | filters                           | table    | foreman
 public | filters_id_seq                    | sequence | foreman
 public | host_classes                      | table    | foreman
 public | host_classes_id_seq               | sequence | foreman
 public | host_config_groups                | table    | foreman
 public | host_config_groups_id_seq         | sequence | foreman
 public | hostgroup_classes                 | table    | foreman
 public | hostgroup_classes_id_seq          | sequence | foreman
 public | hostgroups                        | table    | foreman
 public | hostgroups_id_seq                 | sequence | foreman
 public | hosts                             | table    | foreman
 public | hosts_id_seq                      | sequence | foreman
 public | images                            | table    | foreman
 public | images_id_seq                     | sequence | foreman
 public | key_pairs                         | table    | foreman
 public | key_pairs_id_seq                  | sequence | foreman
 public | locations_organizations           | table    | foreman
 public | logs                              | table    | foreman
 public | logs_id_seq                       | sequence | foreman
 public | lookup_keys                       | table    | foreman
 public | lookup_keys_id_seq                | sequence | foreman
 public | lookup_values                     | table    | foreman
 public | lookup_values_id_seq              | sequence | foreman
 public | mail_notifications                | table    | root
 public | mail_notifications_id_seq         | sequence | root
 public | media                             | table    | foreman
 public | media_id_seq                      | sequence | foreman
 public | media_operatingsystems            | table    | foreman
 public | messages                          | table    | foreman
 public | messages_id_seq                   | sequence | foreman
 public | models                            | table    | foreman
 public | models_id_seq                     | sequence | foreman
 public | nics                              | table    | foreman
 public | nics_id_seq                       | sequence | foreman
 public | operatingsystems                  | table    | foreman
 public | operatingsystems_id_seq           | sequence | foreman
 public | operatingsystems_ptables          | table    | foreman
 public | operatingsystems_puppetclasses    | table    | foreman
 public | os_default_templates              | table    | foreman
 public | os_default_templates_id_seq       | sequence | foreman
 public | parameters                        | table    | foreman
 public | parameters_id_seq                 | sequence | foreman
 public | permissions                       | table    | foreman
 public | permissions_id_seq                | sequence | foreman
 public | ptables                           | table    | foreman
 public | ptables_id_seq                    | sequence | foreman
 public | puppetclasses                     | table    | foreman
 public | puppetclasses_id_seq              | sequence | foreman
 public | realms                            | table    | foreman
 public | realms_id_seq                     | sequence | foreman
 public | reports                           | table    | foreman
 public | reports_id_seq                    | sequence | foreman
 public | roles                             | table    | foreman
 public | roles_id_seq                      | sequence | foreman
 public | schema_migrations                 | table    | foreman
 public | sessions                          | table    | foreman
 public | sessions_id_seq                   | sequence | foreman
 public | settings                          | table    | foreman
 public | settings_id_seq                   | sequence | foreman
 public | setup_provisioners                | table    | foreman
 public | setup_provisioners_id_seq         | sequence | foreman
 public | smart_proxies                     | table    | foreman
 public | smart_proxies_id_seq              | sequence | foreman
 public | sources                           | table    | foreman
 public | sources_id_seq                    | sequence | foreman
 public | subnet_domains                    | table    | foreman
 public | subnet_domains_id_seq             | sequence | foreman
 public | subnets                           | table    | foreman
 public | subnets_id_seq                    | sequence | foreman
 public | taxable_taxonomies                | table    | foreman
 public | taxable_taxonomies_id_seq         | sequence | foreman
 public | taxonomies                        | table    | foreman
 public | taxonomies_id_seq                 | sequence | foreman
 public | template_combinations             | table    | foreman
 public | template_combinations_id_seq      | sequence | foreman
 public | template_kinds                    | table    | foreman
 public | template_kinds_id_seq             | sequence | foreman
 public | tokens                            | table    | foreman
 public | tokens_id_seq                     | sequence | foreman
 public | trend_counters                    | table    | foreman
 public | trend_counters_id_seq             | sequence | foreman
 public | trends                            | table    | foreman
 public | trends_id_seq                     | sequence | foreman
 public | user_mail_notifications           | table    | root
 public | user_mail_notifications_id_seq    | sequence | root
 public | user_roles                        | table    | foreman
 public | user_roles_id_seq                 | sequence | foreman
 public | usergroup_members                 | table    | foreman
 public | usergroup_members_id_seq          | sequence | foreman
 public | usergroups                        | table    | foreman
 public | usergroups_id_seq                 | sequence | foreman
 public | users                             | table    | foreman
 public | users_id_seq                      | sequence | foreman
(136 rows)

foreman=# alter table mail_notifications owner to foreman;
ALTER TABLE
foreman=# alter table mail_notifications_id_seq owner to foreman;
ALTER TABLE
foreman=# alter table user_mail_notifications owner to foreman;
ALTER TABLE
foreman=# alter table user_mail_notifications_id_seq owner to foreman;
ALTER TABLE
foreman=#

foreman=# \d
                        List of relations
 Schema |               Name                |   Type   |  Owner
--------+-----------------------------------+----------+---------
 public | architectures                     | table    | foreman
 public | architectures_id_seq              | sequence | foreman
 public | architectures_operatingsystems    | table    | foreman
 public | audits                            | table    | foreman
 public | audits_id_seq                     | sequence | foreman
 public | auth_sources                      | table    | foreman
 public | auth_sources_id_seq               | sequence | foreman
 public | bookmarks                         | table    | foreman
 public | bookmarks_id_seq                  | sequence | foreman
 public | cached_user_roles                 | table    | foreman
 public | cached_user_roles_id_seq          | sequence | foreman
 public | cached_usergroup_members          | table    | foreman
 public | cached_usergroup_members_id_seq   | sequence | foreman
 public | compute_attributes                | table    | foreman
 public | compute_attributes_id_seq         | sequence | foreman
 public | compute_profiles                  | table    | foreman
 public | compute_profiles_id_seq           | sequence | foreman
 public | compute_resources                 | table    | foreman
 public | compute_resources_id_seq          | sequence | foreman
 public | config_group_classes              | table    | foreman
 public | config_group_classes_id_seq       | sequence | foreman
 public | config_groups                     | table    | foreman
 public | config_groups_id_seq              | sequence | foreman
 public | config_templates                  | table    | foreman
 public | config_templates_id_seq           | sequence | foreman
 public | config_templates_operatingsystems | table    | foreman
 public | domains                           | table    | foreman
 public | domains_id_seq                    | sequence | foreman
 public | environment_classes               | table    | foreman
 public | environment_classes_id_seq        | sequence | foreman
 public | environments                      | table    | foreman
 public | environments_id_seq               | sequence | foreman
 public | external_usergroups               | table    | foreman
 public | external_usergroups_id_seq        | sequence | foreman
 public | fact_names                        | table    | foreman
 public | fact_names_id_seq                 | sequence | foreman
 public | fact_values                       | table    | foreman
 public | fact_values_id_seq                | sequence | foreman
 public | features                          | table    | foreman
 public | features_id_seq                   | sequence | foreman
 public | features_smart_proxies            | table    | foreman
 public | filterings                        | table    | foreman
 public | filterings_id_seq                 | sequence | foreman
 public | filters                           | table    | foreman
 public | filters_id_seq                    | sequence | foreman
 public | host_classes                      | table    | foreman
 public | host_classes_id_seq               | sequence | foreman
 public | host_config_groups                | table    | foreman
 public | host_config_groups_id_seq         | sequence | foreman
 public | hostgroup_classes                 | table    | foreman
 public | hostgroup_classes_id_seq          | sequence | foreman
 public | hostgroups                        | table    | foreman
 public | hostgroups_id_seq                 | sequence | foreman
 public | hosts                             | table    | foreman
 public | hosts_id_seq                      | sequence | foreman
 public | images                            | table    | foreman
 public | images_id_seq                     | sequence | foreman
 public | key_pairs                         | table    | foreman
 public | key_pairs_id_seq                  | sequence | foreman
 public | locations_organizations           | table    | foreman
 public | logs                              | table    | foreman
 public | logs_id_seq                       | sequence | foreman
 public | lookup_keys                       | table    | foreman
 public | lookup_keys_id_seq                | sequence | foreman
 public | lookup_values                     | table    | foreman
 public | lookup_values_id_seq              | sequence | foreman
 public | mail_notifications                | table    | foreman
 public | mail_notifications_id_seq         | sequence | foreman
 public | media                             | table    | foreman
 public | media_id_seq                      | sequence | foreman
 public | media_operatingsystems            | table    | foreman
 public | messages                          | table    | foreman
 public | messages_id_seq                   | sequence | foreman
 public | models                            | table    | foreman
 public | models_id_seq                     | sequence | foreman
 public | nics                              | table    | foreman
 public | nics_id_seq                       | sequence | foreman
 public | operatingsystems                  | table    | foreman
 public | operatingsystems_id_seq           | sequence | foreman
 public | operatingsystems_ptables          | table    | foreman
 public | operatingsystems_puppetclasses    | table    | foreman
 public | os_default_templates              | table    | foreman
 public | os_default_templates_id_seq       | sequence | foreman
 public | parameters                        | table    | foreman
 public | parameters_id_seq                 | sequence | foreman
 public | permissions                       | table    | foreman
 public | permissions_id_seq                | sequence | foreman
 public | ptables                           | table    | foreman
 public | ptables_id_seq                    | sequence | foreman
 public | puppetclasses                     | table    | foreman
 public | puppetclasses_id_seq              | sequence | foreman
 public | realms                            | table    | foreman
 public | realms_id_seq                     | sequence | foreman
 public | reports                           | table    | foreman
 public | reports_id_seq                    | sequence | foreman
 public | roles                             | table    | foreman
 public | roles_id_seq                      | sequence | foreman
 public | schema_migrations                 | table    | foreman
 public | sessions                          | table    | foreman
 public | sessions_id_seq                   | sequence | foreman
 public | settings                          | table    | foreman
 public | settings_id_seq                   | sequence | foreman
 public | setup_provisioners                | table    | foreman
 public | setup_provisioners_id_seq         | sequence | foreman
 public | smart_proxies                     | table    | foreman
 public | smart_proxies_id_seq              | sequence | foreman
 public | sources                           | table    | foreman
 public | sources_id_seq                    | sequence | foreman
 public | subnet_domains                    | table    | foreman
 public | subnet_domains_id_seq             | sequence | foreman
 public | subnets                           | table    | foreman
 public | subnets_id_seq                    | sequence | foreman
 public | taxable_taxonomies                | table    | foreman
 public | taxable_taxonomies_id_seq         | sequence | foreman
 public | taxonomies                        | table    | foreman
 public | taxonomies_id_seq                 | sequence | foreman
 public | template_combinations             | table    | foreman
 public | template_combinations_id_seq      | sequence | foreman
 public | template_kinds                    | table    | foreman
 public | template_kinds_id_seq             | sequence | foreman
 public | tokens                            | table    | foreman
 public | tokens_id_seq                     | sequence | foreman
 public | trend_counters                    | table    | foreman
 public | trend_counters_id_seq             | sequence | foreman
 public | trends                            | table    | foreman
 public | trends_id_seq                     | sequence | foreman
 public | user_mail_notifications           | table    | foreman
 public | user_mail_notifications_id_seq    | sequence | foreman
 public | user_roles                        | table    | foreman
 public | user_roles_id_seq                 | sequence | foreman
 public | usergroup_members                 | table    | foreman
 public | usergroup_members_id_seq          | sequence | foreman
 public | usergroups                        | table    | foreman
 public | usergroups_id_seq                 | sequence | foreman
 public | users                             | table    | foreman
 public | users_id_seq                      | sequence | foreman
(136 rows)

foreman=#
Notes of a Systems Administrator

Friday, 19 December 2014

How to fix 'PG::InsufficientPrivilege: ERROR: permission denied' problem

Thursday, 18 December 2014

Port bonding on Solaris 10 - LACP

Wednesday, 17 December 2014

Reseting Postgres user password - create root user and grant superuser
