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_role

User roles usable for users within your Organizations and Teams. The column category signifies where the role can be used.

Key columns

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

Examples

List of all User Roles available in the account

select
  id,
  name,
  subsidiary,
  category,
  permissions
from
  make_user_role;

List of all Admins in the account

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

Schema for make_user_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
category	text		Can the Role be used on the Organization, or Team level?
id	bigint		The user ID.
name	text		The name of the Role.
permissions	jsonb		Permissions of the users in the Role.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
subsidiary	boolean		Is the Role defined in an Organization, or is it part of the account?
title	text		The display name for the resource.