Project

General

Profile

Bug #21158 ยป 21158.txt

Javier Vela, 11/03/2017 09:36 AM

 
foreman=# select permissions.name, permissions.resource_type, filters.role_id from permissions inner join filterings on filterings.permission_id = permissions.id inner join filters on filters.id = filterings.filter_id;
name | resource_type | role_id
-------------------------------------------------+------------------------------+---------
view_foreman_tasks | ForemanTasks::Task | 1
edit_foreman_tasks | ForemanTasks::Task | 1
view_foreman_tasks | ForemanTasks::Task | 2
download_bootdisk | | 3
view_architectures | Architecture | 4
create_architectures | Architecture | 4
edit_architectures | Architecture | 4
destroy_architectures | Architecture | 4
view_audit_logs | Audit | 4
view_authenticators | AuthSourceLdap | 4
create_authenticators | AuthSourceLdap | 4
edit_authenticators | AuthSourceLdap | 4
destroy_authenticators | AuthSourceLdap | 4
view_bookmarks | Bookmark | 4
create_bookmarks | Bookmark | 4
edit_bookmarks | Bookmark | 4
destroy_bookmarks | Bookmark | 4
view_compute_resources | ComputeResource | 4
create_compute_resources | ComputeResource | 4
edit_compute_resources | ComputeResource | 4
destroy_compute_resources | ComputeResource | 4
view_compute_resources_vms | ComputeResource | 4
create_compute_resources_vms | ComputeResource | 4
edit_compute_resources_vms | ComputeResource | 4
destroy_compute_resources_vms | ComputeResource | 4
power_compute_resources_vms | ComputeResource | 4
console_compute_resources_vms | ComputeResource | 4
view_provisioning_templates | ProvisioningTemplate | 4
create_provisioning_templates | ProvisioningTemplate | 4
edit_provisioning_templates | ProvisioningTemplate | 4
destroy_provisioning_templates | ProvisioningTemplate | 4
deploy_provisioning_templates | ProvisioningTemplate | 4
access_dashboard | | 4
view_plugins | | 4
access_settings | | 4
view_statistics | | 4
view_tasks | | 4
view_domains | Domain | 4
create_domains | Domain | 4
edit_domains | Domain | 4
destroy_domains | Domain | 4
view_environments | Environment | 4
create_environments | Environment | 4
edit_environments | Environment | 4
destroy_environments | Environment | 4
import_environments | Environment | 4
view_external_variables | VariableLookupKey | 4
create_external_variables | VariableLookupKey | 4
edit_external_variables | VariableLookupKey | 4
destroy_external_variables | VariableLookupKey | 4
view_facts | FactValue | 4
upload_facts | FactValue | 4
edit_classes | HostClass | 4
create_params | Parameter | 4
edit_params | Parameter | 4
destroy_params | Parameter | 4
view_hostgroups | Hostgroup | 4
create_hostgroups | Hostgroup | 4
edit_hostgroups | Hostgroup | 4
destroy_hostgroups | Hostgroup | 4
view_hosts | Host | 4
create_hosts | Host | 4
edit_hosts | Host | 4
destroy_hosts | Host | 4
build_hosts | Host | 4
power_hosts | Host | 4
console_hosts | Host | 4
ipmi_boot_hosts | Host | 4
puppetrun_hosts | Host | 4
view_images | Image | 4
create_images | Image | 4
edit_images | Image | 4
destroy_images | Image | 4
view_locations | Location | 4
create_locations | Location | 4
edit_locations | Location | 4
destroy_locations | Location | 4
assign_locations | Location | 4
view_mail_notifications | MailNotification | 4
view_media | Medium | 4
create_media | Medium | 4
edit_media | Medium | 4
destroy_media | Medium | 4
view_models | Model | 4
create_models | Model | 4
edit_models | Model | 4
destroy_models | Model | 4
view_operatingsystems | Operatingsystem | 4
create_operatingsystems | Operatingsystem | 4
edit_operatingsystems | Operatingsystem | 4
destroy_operatingsystems | Operatingsystem | 4
view_organizations | Organization | 4
create_organizations | Organization | 4
edit_organizations | Organization | 4
destroy_organizations | Organization | 4
assign_organizations | Organization | 4
view_ptables | Ptable | 4
create_ptables | Ptable | 4
edit_ptables | Ptable | 4
destroy_ptables | Ptable | 4
view_puppetclasses | Puppetclass | 4
create_puppetclasses | Puppetclass | 4
edit_puppetclasses | Puppetclass | 4
destroy_puppetclasses | Puppetclass | 4
import_puppetclasses | Puppetclass | 4
view_realms | Realm | 4
create_realms | Realm | 4
edit_realms | Realm | 4
destroy_realms | Realm | 4
view_reports | Report | 4
destroy_reports | Report | 4
upload_reports | Report | 4
view_smart_proxies | SmartProxy | 4
create_smart_proxies | SmartProxy | 4
edit_smart_proxies | SmartProxy | 4
destroy_smart_proxies | SmartProxy | 4
view_smart_proxies_autosign | SmartProxy | 4
create_smart_proxies_autosign | SmartProxy | 4
destroy_smart_proxies_autosign | SmartProxy | 4
view_smart_proxies_puppetca | SmartProxy | 4
edit_smart_proxies_puppetca | SmartProxy | 4
destroy_smart_proxies_puppetca | SmartProxy | 4
view_subnets | Subnet | 4
create_subnets | Subnet | 4
edit_subnets | Subnet | 4
destroy_subnets | Subnet | 4
import_subnets | Subnet | 4
view_trends | Trend | 4
create_trends | Trend | 4
edit_trends | Trend | 4
destroy_trends | Trend | 4
update_trends | Trend | 4
view_usergroups | Usergroup | 4
create_usergroups | Usergroup | 4
edit_usergroups | Usergroup | 4
destroy_usergroups | Usergroup | 4
view_users | User | 4
create_users | User | 4
edit_users | User | 4
destroy_users | User | 4
view_ptables | Ptable | 5
create_ptables | Ptable | 5
edit_ptables | Ptable | 5
destroy_ptables | Ptable | 5
view_hosts | Host | 6
view_hosts | Host | 7
create_hosts | Host | 7
edit_hosts | Host | 7
destroy_hosts | Host | 7
build_hosts | Host | 7
view_architectures | Architecture | 8
view_audit_logs | Audit | 8
view_authenticators | AuthSourceLdap | 8
view_bookmarks | Bookmark | 8
view_compute_profiles | ComputeProfile | 8
view_compute_resources | ComputeResource | 8
view_compute_resources_vms | ComputeResource | 8
view_provisioning_templates | ProvisioningTemplate | 8
view_config_groups | ConfigGroup | 8
access_dashboard | | 8
view_plugins | | 8
access_settings | | 8
view_statistics | | 8
view_tasks | | 8
view_content_reports | | 8
view_domains | Domain | 8
view_environments | Environment | 8
view_external_usergroups | ExternalUsergroups | 8
view_external_variables | VariableLookupKey | 8
view_facts | FactValue | 8
view_filters | Filter | 8
view_hostgroups | Hostgroup | 8
view_hosts | Host | 8
view_images | Image | 8
view_locations | Location | 8
view_mail_notifications | MailNotification | 8
view_media | Medium | 8
view_models | Model | 8
view_operatingsystems | Operatingsystem | 8
view_organizations | Organization | 8
view_subscriptions | Katello::Subscription | 8
view_ptables | Ptable | 8
view_puppetclasses | Puppetclass | 8
view_realms | Realm | 8
view_reports | Report | 8
view_roles | Role | 8
view_smart_proxies | SmartProxy | 8
view_smart_proxies_autosign | SmartProxy | 8
view_smart_proxies_puppetca | SmartProxy | 8
view_subnets | Subnet | 8
view_trends | Trend | 8
view_usergroups | Usergroup | 8
view_users | User | 8
view_foreman_tasks | ForemanTasks::Task | 8
view_recurring_logics | ForemanTasks::RecurringLogic | 8
view_containers | Container | 8
view_registries | DockerRegistry | 8
view_content_views | Katello::ContentView | 8
build_hosts | Host | 13
create_params | Parameter | 4
edit_params | Parameter | 4
destroy_params | Parameter | 4
view_params | Parameter | 4
view_sync_plans | Katello::SyncPlan | 8
view_host_collections | Katello::HostCollection | 8
view_gpg_keys | Katello::GpgKey | 8
view_lifecycle_environments | Katello::KTEnvironment | 8
promote_or_remove_content_views_to_environments | Katello::KTEnvironment | 8
view_products | Katello::Product | 8
view_activation_keys | Katello::ActivationKey | 8
view_architectures | Architecture | 9
view_audit_logs | Audit | 9
view_authenticators | AuthSourceLdap | 9
access_dashboard | | 9
access_settings | | 9
view_statistics | | 9
view_domains | Domain | 9
view_environments | Environment | 9
import_environments | Environment | 9
view_external_variables | VariableLookupKey | 9
create_external_variables | VariableLookupKey | 9
edit_external_variables | VariableLookupKey | 9
destroy_external_variables | VariableLookupKey | 9
view_facts | FactValue | 9
view_hostgroups | Hostgroup | 9
view_hosts | Host | 9
create_hosts | Host | 9
edit_hosts | Host | 9
destroy_hosts | Host | 9
build_hosts | Host | 9
view_mail_notifications | MailNotification | 9
view_media | Medium | 9
create_media | Medium | 9
edit_media | Medium | 9
destroy_media | Medium | 9
view_models | Model | 9
view_operatingsystems | Operatingsystem | 9
view_ptables | Ptable | 9
view_puppetclasses | Puppetclass | 9
import_puppetclasses | Puppetclass | 9
view_realms | Realm | 9
view_reports | Report | 9
destroy_reports | Report | 9
view_smart_proxies | SmartProxy | 9
edit_smart_proxies | SmartProxy | 9
view_smart_proxies_autosign | SmartProxy | 9
view_smart_proxies_puppetca | SmartProxy | 9
view_subnets | Subnet | 9
edit_subnets | Subnet | 9
view_usergroups | Usergroup | 9
create_usergroups | Usergroup | 9
edit_usergroups | Usergroup | 9
destroy_usergroups | Usergroup | 9
view_users | User | 9
edit_users | User | 9
view_params | Parameter | 8
view_params | Parameter | 9
view_bookmarks | Bookmark | 11
view_tasks | | 11
view_foreman_tasks | ForemanTasks::Task | 11
view_locations | Location | 12
view_organizations | Organization | 12
view_discovered_hosts | Host | 12
view_discovery_rules | DiscoveryRule | 12
view_locations | Location | 13
assign_locations | Location | 13
view_organizations | Organization | 13
assign_organizations | Organization | 13
view_discovered_hosts | Host | 13
submit_discovered_hosts | Host | 13
auto_provision_discovered_hosts | Host | 13
provision_discovered_hosts | Host | 13
edit_discovered_hosts | Host | 13
destroy_discovered_hosts | Host | 13
view_discovery_rules | DiscoveryRule | 13
create_discovery_rules | DiscoveryRule | 13
edit_discovery_rules | DiscoveryRule | 13
execute_discovery_rules | DiscoveryRule | 13
destroy_discovery_rules | DiscoveryRule | 13
submit_discovered_hosts | Host | 13
auto_provision_discovered_hosts | Host | 13
view_hosts | Host | 14
view_smart_proxies | SmartProxy | 14
view_job_templates | JobTemplate | 14
create_job_invocations | JobInvocation | 14
view_job_invocations | JobInvocation | 14
execute_template_invocation | TemplateInvocation | 14
view_audit_logs | Audit | 15
view_hosts | Host | 15
view_smart_proxies | SmartProxy | 15
view_job_templates | JobTemplate | 15
create_job_templates | JobTemplate | 15
edit_job_templates | JobTemplate | 15
destroy_job_templates | JobTemplate | 15
lock_job_templates | JobTemplate | 15
create_job_invocations | JobInvocation | 15
view_job_invocations | JobInvocation | 15
execute_template_invocation | TemplateInvocation | 15
filter_autocompletion_for_template_invocation | TemplateInvocation | 15
edit_provisioning | ForemanSetup::Provisioner | 16
view_external_parameters | PuppetclassLookupKey | 8
view_external_parameters | PuppetclassLookupKey | 8
view_external_parameters | PuppetclassLookupKey | 4
view_external_parameters | PuppetclassLookupKey | 4
view_external_parameters | PuppetclassLookupKey | 9
view_external_parameters | PuppetclassLookupKey | 9
create_external_parameters | PuppetclassLookupKey | 9
create_external_parameters | PuppetclassLookupKey | 9
create_external_parameters | PuppetclassLookupKey | 4
create_external_parameters | PuppetclassLookupKey | 4
edit_external_parameters | PuppetclassLookupKey | 9
edit_external_parameters | PuppetclassLookupKey | 9
edit_external_parameters | PuppetclassLookupKey | 4
edit_external_parameters | PuppetclassLookupKey | 4
destroy_external_parameters | PuppetclassLookupKey | 4
destroy_external_parameters | PuppetclassLookupKey | 4
destroy_external_parameters | PuppetclassLookupKey | 9
destroy_external_parameters | PuppetclassLookupKey | 9
view_architectures | Architecture | 12
view_provisioning_templates | ProvisioningTemplate | 12
view_domains | Domain | 12
view_environments | Environment | 12
view_hostgroups | Hostgroup | 12
view_hosts | Host | 12
view_media | Medium | 12
view_models | Model | 12
view_operatingsystems | Operatingsystem | 12
view_ptables | Ptable | 12
view_puppetclasses | Puppetclass | 12
view_realms | Realm | 12
view_smart_proxies | SmartProxy | 12
view_subnets | Subnet | 12
view_architectures | Architecture | 13
view_provisioning_templates | ProvisioningTemplate | 13
view_domains | Domain | 13
view_environments | Environment | 13
view_hostgroups | Hostgroup | 13
view_hosts | Host | 13
create_hosts | Host | 13
view_media | Medium | 13
view_models | Model | 13
view_operatingsystems | Operatingsystem | 13
view_ptables | Ptable | 13
view_puppetclasses | Puppetclass | 13
view_realms | Realm | 13
view_smart_proxies | SmartProxy | 13
view_subnets | Subnet | 13
view_params | Parameter | 4
view_params | Parameter | 8
view_params | Parameter | 9
(350 rows)

foreman=#
    (1-1/1)