v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Hub

Plugins Mods Docs Home

Plugins

marekjalovec/make

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	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
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.
subsidiary	boolean	Is the Role defined in an Organization, or is it part of the account?
title	text	The display name for the resource.