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

[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=#

Port bonding on Solaris 10 - LACP

thelma# dladm show-link
e1000g0         type: non-vlan  mtu: 1500       device: e1000g0
e1000g1         type: non-vlan  mtu: 1500       device: e1000g1
e1000g2         type: non-vlan  mtu: 1500       device: e1000g2
e1000g3         type: non-vlan  mtu: 1500       device: e1000g3
nxge4           type: non-vlan  mtu: 9194       device: nxge4
nxge5           type: non-vlan  mtu: 9194       device: nxge5
nxge0           type: non-vlan  mtu: 9194       device: nxge0
nxge1           type: non-vlan  mtu: 9194       device: nxge1
nxge2           type: non-vlan  mtu: 9194       device: nxge2
nxge3           type: non-vlan  mtu: 9194       device: nxge3
aggr1           type: non-vlan  mtu: 1500       aggregation: key 1
aggr2           type: non-vlan  mtu: 1500       aggregation: key 2

thelma# ifconfig -a
lo0: flags=2001000849 mtu 8232 index 1
        inet 127.0.0.1 netmask ff000000
aggr1: flags=1000843 mtu 1500 index 2
        inet 137.222.10.10 netmask ffffff00 broadcast 137.222.10.255
        groupname ten-link
        ether 0:21:28:17:49:22
aggr1:1: flags=1000843 mtu 1500 index 2
        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255
aggr2: flags=69000842 mtu 0 index 3
        inet 0.0.0.0 netmask 0
        groupname ten-link
        ether 0:21:28:17:49:23
e1000g2: flags=1000843 mtu 1500 index 4
        inet 172.16.61.28 netmask ffffff00 broadcast 172.16.61.255
        ether 0:21:28:17:49:24
e1000g3: flags=1000843 mtu 1500 index 5
        inet 172.16.66.28 netmask ffffff00 broadcast 172.16.66.255
        ether 0:21:28:17:49:25

thelma# dladm create-aggr -l active -d nxge4 -d nxge5 3

thelma# ifconfig aggr3 plumb 10.10.7.3 netmask 255.255.255.0 up

thelma# dladm show-link
e1000g0         type: non-vlan  mtu: 1500       device: e1000g0
e1000g1         type: non-vlan  mtu: 1500       device: e1000g1
e1000g2         type: non-vlan  mtu: 1500       device: e1000g2
e1000g3         type: non-vlan  mtu: 1500       device: e1000g3
nxge4           type: non-vlan  mtu: 9194       device: nxge4
nxge5           type: non-vlan  mtu: 9194       device: nxge5
nxge0           type: non-vlan  mtu: 9194       device: nxge0
nxge1           type: non-vlan  mtu: 9194       device: nxge1
nxge2           type: non-vlan  mtu: 9194       device: nxge2
nxge3           type: non-vlan  mtu: 9194       device: nxge3
aggr1           type: non-vlan  mtu: 1500       aggregation: key 1
aggr2           type: non-vlan  mtu: 1500       aggregation: key 2
aggr3           type: non-vlan  mtu: 9194       aggregation: key 3

thelma# ifconfig -a
lo0: flags=2001000849 mtu 8232 index 1
        inet 127.0.0.1 netmask ff000000
aggr1: flags=1000843 mtu 1500 index 2
        inet 137.222.10.10 netmask ffffff00 broadcast 137.222.10.255
        groupname ten-link
        ether 0:21:28:17:49:22
aggr1:1: flags=1000843 mtu 1500 index 2
        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255
aggr2: flags=69000842 mtu 0 index 3
        inet 0.0.0.0 netmask 0
        groupname ten-link
        ether 0:21:28:17:49:23
aggr3: flags=1000843 mtu 9194 index 8
        inet 10.10.7.1 netmask ffffff00 broadcast 10.10.7.255
        ether 0:21:28:8a:89:b0
e1000g2: flags=1000843 mtu 1500 index 4
        inet 172.16.61.28 netmask ffffff00 broadcast 172.16.61.255
        ether 0:21:28:17:49:24
e1000g3: flags=1000843 mtu 1500 index 5
        inet 172.16.66.28 netmask ffffff00 broadcast 172.16.66.255
        ether 0:21:28:17:49:25

thelma#  dladm show-aggr -s

key:1           ipackets   rbytes       opackets   obytes       %ipkts  %opkts
        Total   953501     89701761     21760      3095518
        e1000g0 645484     59281349     10336      1444661        67.7    47.5
        nxge0   203861     19536426     4465       713388         21.4    20.5
        nxge2   104156     10883986     6959       937469         10.9    32.0

key:2           ipackets   rbytes       opackets   obytes       %ipkts  %opkts
        Total   937620     87621942     6843       930648
        e1000g1 642508     58920448     2281       291968         68.5    33.3
        nxge1   196217     18325508     2282       319480         20.9    33.3
        nxge3   98895      10375986     2280       319200         10.5    33.3

key:3           ipackets   rbytes       opackets   obytes       %ipkts  %opkts
        Total   73109      8562586      15442      2100226
        nxge4   2648       321376       5397       755580          3.6    35.0
        nxge5   70461      8241210      10045      1344646        96.4    65.0

thelma#  dladm show-aggr -L
key: 1 (0x0001) policy: L4      address: 0:21:28:17:49:22 (auto)
                LACP mode: active       LACP timer: short
    device    activity timeout aggregatable sync  coll dist defaulted expired
    e1000g0   active   short   yes          yes   yes  yes  no        no
    nxge0     active   short   yes          yes   yes  yes  no        no
    nxge2     active   short   yes          yes   yes  yes  no        no
key: 2 (0x0002) policy: L4      address: 0:21:28:17:49:23 (auto)
                LACP mode: active       LACP timer: short
    device    activity timeout aggregatable sync  coll dist defaulted expired
    e1000g1   active   short   yes          yes   yes  yes  no        no
    nxge1     active   short   yes          yes   yes  yes  no        no
    nxge3     active   short   yes          yes   yes  yes  no        no
key: 3 (0x0003) policy: L4      address: 0:21:28:8a:89:b0 (auto)
                LACP mode: active       LACP timer: short
    device    activity timeout aggregatable sync  coll dist defaulted expired
    nxge4     active   short   yes          no    no   no   yes       no
    nxge5     active   short   yes          yes   yes  yes  no        no
thelma#

Reseting Postgres user password - create root user and grant superuser

As root user on the system, edit the pg_hba.conf

# vi /var/lib/pgsql/data/pg_hba.conf

# This file is managed by Puppet. DO NOT EDIT.

# Rule Name: local access as postgres user
# Description: none
# Order: 001
#local all postgres  ident 
local all postgres  md5 

# sudo -u postgres psql
psql (8.4.20)
Type "help" for help.

postgres=# \password postgres
Enter new password: 
Enter it again: 
postgres=# \quit

# psql -U postgres -W
Password for user postgres: 
psql (8.4.20)
Type "help" for help.

postgres=# create user root with password '';
CREATE ROLE
postgres=# alter user root with superuser;
ALTER ROLE
postgres=# 

Running ruby193 under software collections (scl)

$  scl enable ruby193 'bundle install'
$  gem install sqlite3 -v '1.3.10'
$  scl enable ruby193 'gem install sqlite3 -v '1.3.10''
$  mv Gemfile Gemfile.in
$  scl enable ruby193 'rake db:migrate'

Uninstall a whole load of packages at once!

Using yum to uninstall all ruby packages that has the string rhscl in them:

$ yum list installed|grep ruby|grep rhscl|awk '{print $1}'| xargs yum -y remove 

Like-wise for ruby under foreman and scl:

$ yum list installed|grep ruby|grep foreman|awk '{print $1}'| xargs yum -y remove 
$ yum list installed|grep ruby|grep scl|awk '{print $1}'| xargs yum -y remove 

Nintendo 3DS - Xbox One - Nintendo Wii - PS4 - PS Vita

Install Repository Keys - Apt-get update - gpg --recv-keys

When running apt-get update, you get this error:

(0) root@debiansvr /var/tmp
# apt-get update
Get:1 http://packages.yourdomain wheezy Release.gpg [490 B]
Get:2 http://packages.yourdomain wheezy Release [3,489 B]
Get:3 http://ftp.uk.debian.org wheezy Release.gpg [1,655 B]
Ign http://packages.yourdomain wheezy Release
Get:4 http://ftp.uk.debian.org wheezy Release [168 kB]
Get:5 http://security.debian.org wheezy/updates Release.gpg [836 B]
Get:6 http://security.debian.org wheezy/updates Release [102 kB]
Get:7 http://ftp.uk.debian.org wheezy/main Sources [5,955 kB]
Get:8 http://security.debian.org wheezy/updates/main Sources [142 kB]
Get:9 http://packages.yourdomain wheezy/main Sources [6,892 B]
Get:10 http://packages.yourdomain wheezy/main i386 Packages [6,883 B]
Ign http://packages.yourdomain wheezy/main Translation-en_GB
Ign http://packages.yourdomain wheezy/main Translation-en
Get:11 http://security.debian.org wheezy/updates/contrib Sources [14 B]
Get:12 http://security.debian.org wheezy/updates/non-free Sources [14 B]
Get:13 http://security.debian.org wheezy/updates/main i386 Packages [228 kB]
Get:14 http://security.debian.org wheezy/updates/contrib i386 Packages [14 B]
Get:15 http://security.debian.org wheezy/updates/non-free i386 Packages [14 B]
Get:16 http://security.debian.org wheezy/updates/contrib Translation-en [14 B]
Get:17 http://security.debian.org wheezy/updates/main Translation-en [128 kB]
Get:18 http://security.debian.org wheezy/updates/non-free Translation-en [14 B]
Get:19 http://ftp.uk.debian.org wheezy/contrib Sources [47.8 kB]
Get:20 http://ftp.uk.debian.org wheezy/non-free Sources [93.4 kB]
Get:21 http://ftp.uk.debian.org wheezy/main i386 Packages [5,858 kB]
Get:22 http://ftp.uk.debian.org wheezy/contrib i386 Packages [42.3 kB]
Get:23 http://ftp.uk.debian.org wheezy/non-free i386 Packages [77.5 kB]
Get:24 http://ftp.uk.debian.org wheezy/contrib Translation-en [34.8 kB]
Get:25 http://ftp.uk.debian.org wheezy/main Translation-en [3,846 kB]
Get:26 http://ftp.uk.debian.org wheezy/non-free Translation-en [66.1 kB]
Fetched 16.8 MB in 15s (1,064 kB/s)
Reading package lists... Done
W: GPG error: http://packages.yourdomain wheezy Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 1639B68C40E3D96F

Check out which of your keys is missing:

(127) root@debiansvr /var/tmp
# apt-key list
/etc/apt/trusted.gpg
--------------------
pub   1024D/F42584E6 2008-04-06 [expired: 2012-05-15]
uid                  Lenny Stable Release Key 

pub   4096R/55BE302B 2009-01-27 [expired: 2012-12-31]
uid                  Debian Archive Automatic Signing Key (5.0/lenny) 

pub   2048R/6D849617 2009-01-24 [expired: 2013-01-23]
uid                  Debian-Volatile Archive Automatic Signing Key (5.0/lenny)

pub   1024D/DB782D34 2007-10-11
uid                  Matt Baker (Package Maintainer) 
sub   2048g/A5734914 2007-10-11

pub   1024D/7F1D2347 2006-08-23 [expired: 2011-10-20]
uid                  Index Data (Package Key) 

pub   1024D/773F7ECF 2009-03-10 [expires: 2015-03-27]
uid                  Nightly Build (ILRT autonomous builder) 
sub   2048g/DC9C4CFD 2009-03-10 [expires: 2015-03-27]

pub   1024D/DC2698A1 2006-02-23
uid                  steve.org.uk APT key (This key is only used to sign the APT repository at http://www.steve.org.uk/apt/) 
sub   2048g/0CB6CBA8 2006-02-23

pub   4096R/B98321F9 2010-08-07 [expires: 2017-08-05]
uid                  Squeeze Stable Release Key 

pub   4096R/473041FA 2010-08-27 [expires: 2018-03-05]
uid                  Debian Archive Automatic Signing Key (6.0/squeeze) 

pub   4096R/8D77295D 2009-07-12
uid                  Eric Evans 
uid                  Eric Evans 
uid                  Eric Evans 
uid                  Eric Evans 
sub   4096R/C47D63C0 2009-07-12

pub   2048R/2B5C1B00 2011-04-13
uid                  Sylvain Lebresne (pcmanus) 
sub   2048R/9CB2AA80 2011-04-13

pub   1024D/16BA136C 2005-08-21
uid                  Backports.org Archive Key 
sub   2048g/5B82CECE 2005-08-21

pub   4096R/46925553 2012-04-27 [expires: 2020-04-25]
uid                  Debian Archive Automatic Signing Key (7.0/wheezy) 

pub   4096R/65FFB764 2012-05-08 [expires: 2019-05-07]
uid                  Wheezy Stable Release Key 

pub   2048R/40E3D96F 2014-08-06
uid                  UOB package repo admin (Central software repo admin) 
sub   2048R/C92A16D8 2014-08-06

/etc/apt/trusted.gpg.d//debian-archive-jessie-stable.gpg
--------------------------------------------------------
pub   4096R/518E17E1 2013-08-17 [expires: 2021-08-15]
uid                  Jessie Stable Release Key 

/etc/apt/trusted.gpg.d//debian-archive-squeeze-automatic.gpg
------------------------------------------------------------
pub   4096R/473041FA 2010-08-27 [expires: 2018-03-05]
uid                  Debian Archive Automatic Signing Key (6.0/squeeze) 

/etc/apt/trusted.gpg.d//debian-archive-squeeze-stable.gpg
---------------------------------------------------------
pub   4096R/B98321F9 2010-08-07 [expires: 2017-08-05]
uid                  Squeeze Stable Release Key 

/etc/apt/trusted.gpg.d//debian-archive-wheezy-automatic.gpg
-----------------------------------------------------------
pub   4096R/46925553 2012-04-27 [expires: 2020-04-25]
uid                  Debian Archive Automatic Signing Key (7.0/wheezy) 

/etc/apt/trusted.gpg.d//debian-archive-wheezy-stable.gpg
--------------------------------------------------------
pub   4096R/65FFB764 2012-05-08 [expires: 2019-05-07]
uid                  Wheezy Stable Release Key 

(0) root@debiansvr /var/tmp

Download the Release and Release.pgp files of the repos. Get the keys and install them:

$ wget http://packages.yourdomain/debian/dists/wheezy/Release.gpg
$ wget http://packages.yourdomain/debian/dists/wheezy/Release
$ gpg Release.gpg
$ gpg --recv-keys 65FFB764
$ gpg --recv-keys 46925553

or just copy the /etc/apt/trusted.gpg file from a system that works over and run apt-get update ;)