[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=#
Friday, 19 December 2014
How to fix 'PG::InsufficientPrivilege: ERROR: permission denied' problem
Subscribe to:
Posts (Atom)