steampipe plugin install marekjalovec/makesteampipe plugin install marekjalovec/make

make_api_token make_connection make_data_store make_function make_hook make_organization make_organization_variable make_scenario make_scenario_dlq make_scenario_log make_team make_team_variable make_user make_user_organization_role make_user_role make_user_team_role

Table: make_user_organization_role

Assigned User Roles with an Organization.

Key columns

Provide a numeric id if you want to query for a specific User Role assignment.

Examples

List access roles for a specific User

select
  distinct u.name as user_name,
  o.name as organization_name,
  ur.name as role_name,
  ur.permissions
from
  make_user_organization_role uor
  join make_organization o on o.id = uor.organization_id
  join make_user u on u.id = uor.user_id
  join make_user_role ur on ur.id = uor.users_role_id
where
  uor.user_id = 1;

Schema for make_user_organization_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
invitation	text		Invitation string.
organization_id	bigint		The ID of the Organization.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
sso_pending	boolean		Is SSO pending?
title	text		The display name for the resource.
user_id	bigint	=	The user ID.
users_role_id	bigint		The ID of the Role.