Table: openstack_role_assignment

A 3-tuple combining keystone entities in the form of role-user/group-domain or role-user/group-project. Role assignments are domain specific.

Examples

select
  user_id,
  group_id,
  scope_project_id,
  scope_domain_id,
  scope_role_id
from
  openstack_role_assignment;

select
  group_id,
  scope_project_id,
  scope_domain_id,
  scope_role_id
from
  openstack_role_assignment
where
  group_id is not null;

select
  user_id,
  scope_project_id,
  scope_domain_id,
  scope_role_id
from
  openstack_role_assignment
where
  user_id is not null;

select
  user_id,
  scope_project_id,
  scope_domain_id,
  scope_role_id
from
  openstack_role_assignment
where
  scope_domain_id is not null;

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
group_id	text	Group ID the role is assigned to.
scope_domain_id	text	Domain ID the group/user with role is assigned to.
scope_project_id	text	Project ID the group/user with role is assigned to.
scope_role_id	text	ID of the assigned role.
user_id	text	User ID the role is assigned to.