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