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_team_role

Assigned User Roles with a Team.

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,
  t.name as team_name,
  ur.name as role_name,
  ur.permissions
from
  make_user_team_role utr
  join make_team t on t.id = utr.team_id
  join make_user u on u.id = utr.user_id
  join make_user_role ur on ur.id = utr.users_role_id
where
  utr.user_id = 1;

Schema for make_user_team_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
changeable	boolean		Can the Role be changed?
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
team_id	bigint		The ID of the Team.
title	text		The display name for the resource.
user_id	bigint	=	The user ID.
users_role_id	bigint		ID of the Role.