Thursday, 8 January 2015

Calling a Puppet Module in your code

I installed a Puppet module called mit_krb5 so that I could configure Kerberos on my systems. Unfortunately, I was unable to get it to put the correct settings using Foreman, so I wrote some code to do this:
class uobldap {
class { 'mit_krb5':
  default_realm    => 'ADS.BRIS.AC.UK',
  dns_lookup_realm => false,
  dns_lookup_kdc   => false,
  ticket_lifetime  => '24h',
  renew_lifetime   => '7d',
  forwardable      => true,
}
class { 'mit_krb5::logging':
  default      => 'FILE:/var/log/krb5libs.log',
  kdc          => 'FILE:/var/log/krb5kdc.log',
  admin_server => 'FILE:/var/log/kadmind.log'
}
mit_krb5::realm { 'ADS.BRIS.AC.UK':
  kdc          => 'ads.bris.ac.uk',
  admin_server => 'ads.bris.ac.uk'
}
mit_krb5::domain_realm { 'ADS.BRIS.AC.UK':
  domains => ['.ads.bris.ac.uk', 'ads.bris.ac.uk']
}

}

Wednesday, 7 January 2015

PAM configurations - RedHat/CentOS

PAM On RedHat/CentOS systems linked to LDAP, users with UIDs smaller than 500 are not allowed to log on. Change the settings in /etc/pam.d/system-auth file:
 #%PAM-1.0
 # This file is auto-generated.
 # User changes will be destroyed the next time authconfig is run.
 auth        required      pam_env.so
 auth        sufficient    pam_unix.so nullok try_first_pass
 auth        requisite     pam_succeed_if.so uid >= 500 quiet
 auth        sufficient    pam_ldap.so use_first_pass
 auth        required      pam_deny.so

 account     required      pam_unix.so broken_shadow
 account     sufficient    pam_succeed_if.so uid < 500 quiet
 account     [default=bad success=ok user_unknown=ignore] pam_ldap.so
 account     required      pam_permit.so

 password    requisite     pam_cracklib.so try_first_pass retry=3
 password    sufficient    pam_unix.so md5 shadow nullok try_first_pass use_authtok
 password    sufficient    pam_ldap.so use_authtok
 password    required      pam_deny.so

 session     optional      pam_keyinit.so revoke
 session     required      pam_limits.so
 session     [success=1 default=ignore] pam_succeed_if.so service in crond quiet use_uid
 session     required      pam_unix.so
 session     optional      pam_ldap.so
Change 500 to 100 or some smaller number in the first (3rd) line and change the 'uid < 500' to 'uid > 100' in the second (7th). To allow a user's directory to be automatic created on login, add this line to /etc/pam.d/common-account file:
# and here are more per-package modules (the "Additional" block)
session   required      pam_mkhomedir.so        umask=077
account      required      pam_krb5.so minimum_uid=1000
# end of pam-auth-update config

Tuesday, 6 January 2015

Installing Puppet Module break foreman(proxy) - uninstall to fix!

#  puppet module install IvanBayan-krb5
Notice: Preparing to install into /etc/puppet/modules ...
Notice: Downloading from https://forgeapi.puppetlabs.com ...
Warning: Cannot consider release puppet-krb5-0.0.2: Malformed dependency: ripienaar/concat. Exception was: Invalid 'version_range' field in metadata.json: Unparsable version range: ">=1"
Notice: Installing -- do not interrupt ...
/etc/puppet/modules
└─┬ IvanBayan-krb5 (v0.0.3)
  └── puppetlabs-concat (v1.0.0)
Oops, we're sorry but something went wrong Warning! ERF12-4115 [ProxyAPI::ProxyException]: Unable to get classes from Puppet for testing ([RestClient::NotAcceptable]: 406 Not Acceptable) for proxy If you feel this is an error with Foreman itself, please open a new issue with Foreman ticketing system, You would probably need to attach the Full trace and relevant log entries. Back Just uninstall it!
#  puppet module uninstall IvanBayan-krb5
Notice: Preparing to uninstall 'IvanBayan-krb5' ...
Removed 'IvanBayan-krb5' (v0.0.3) from /etc/puppet/modules
What to do when you can't uninstall?
# puppet module install myrond-auto_update_debian
Notice: Preparing to install into /etc/puppet/modules ...
Notice: Downloading from https://forgeapi.puppetlabs.com ...
Notice: Installing -- do not interrupt ...
/etc/puppet/modules
└── myrond-auto_update_debian (v1.0.1)
You have new mail in /var/spool/mail/root
# puppet module uninstall myrond-auto_update_debian
Notice: Preparing to uninstall 'myrond-auto_update_debian' ...
Error: Could not uninstall module 'myrond-auto_update_debian' (v1.0.1)
  Installed module has had changes made locally
    Use `puppet module uninstall --ignore-changes` to uninstall this module anyway
# puppet module uninstall --ignore-changes myrond-auto_update_debian
Notice: Preparing to uninstall 'myrond-auto_update_debian' ...
Removed 'myrond-auto_update_debian' (v1.0.1) from /etc/puppet/modules
#

Monday, 5 January 2015

Unable to install puppet on Debian Wheezy - Size mismatch

When I use the following command to install puppet client:
$ wget http://apt.puppetlabs.com/puppetlabs-release-precise.deb
$ sudo dpkg -i puppetlabs-release-precise.deb
$ sudo apt-get update
$ sudo apt-get install puppet
I get the following Size mismatch errors:
Get:1 http://cdn.debian.net/debian/ wheezy/main virt-what amd64 1.12-1 [12.9 kB]
Get:2 http://apt.puppetlabs.com/ precise/main facter all 2.3.0-1puppetlabs1 [85.5 kB]
Get:3 http://apt.puppetlabs.com/ precise/main hiera all 1.3.4-1puppetlabs1 [12.9 kB]
Get:4 http://apt.puppetlabs.com/ precise/main puppet-common all 3.7.3-1puppetlabs1 [1654 kB]
Get:5 http://apt.puppetlabs.com/ precise/main puppet all 3.7.3-1puppetlabs1 [9624 B]
Fetched 1775 kB in 0s (3117 kB/s)
Failed to fetch http://apt.puppetlabs.com/pool/precise/main/f/facter/facter_2.3.0-1puppetlabs1_all.deb  Size mismatch
Failed to fetch http://apt.puppetlabs.com/pool/precise/main/h/hiera/hiera_1.3.4-1puppetlabs1_all.deb  Size mismatch
Failed to fetch http://apt.puppetlabs.com/pool/precise/main/p/puppet/puppet-common_3.7.3-1puppetlabs1_all.deb  Size mismatch
Failed to fetch http://apt.puppetlabs.com/pool/precise/main/p/puppet/puppet_3.7.3-1puppetlabs1_all.deb  Size mismatch
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?
And no amount of --fix-missing and cache clearing and clean will resolve this issue:
apt-get install puppet --fix-missing
apt-get clean
rm /var/lib/apt/lists/*
rm /var/cache/apt/archives/partial/*
apt-get clean
apt-get update
It turns out that this is an issue in the puppetlabs-release-precise.deb package. So to fix this issue we need to download the SPECIFIC puppetlabs package - in this case for Debian Wheezy:
$ wget http://apt.puppetlabs.com/puppetlabs-release-wheezy.deb
$ dpkg -i puppetlabs-release-wheezy.deb
$ apt-get update
$ apt-get install puppet
All this then fine.

Friday, 19 December 2014

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