Table: zoom_role - Query Zoom Roles using SQL

Zoom Roles is a feature within Zoom that allows administrators to assign permissions to users based on their role. It provides a way to manage access control and permissions for different users within the organization. Zoom Roles help to ensure that users have the appropriate access rights for their job function and responsibilities.

Table Usage Guide

The zoom_role table provides insights into roles within Zoom. As an administrator, explore role-specific details through this table, including role id, name, total members, and privileges. Utilize it to uncover information about roles, such as those with specific permissions, the number of users assigned to each role, and the specific privileges associated with each role.

Examples

List all roles

Explore the various roles within your Zoom account, allowing you to manage and organize your team more effectively. This query helps in maintaining a clear hierarchy and understanding the permissions associated with each role.

select
  *
from
  zoom_role
order by
  name;

select
  *
from
  zoom_role
order by
  name;

Get a role by ID

Discover the segments that are associated with a specific role ID in Zoom to better manage permissions and responsibilities within your team. This can be particularly useful for administrators who need to understand the scope of a role for delegation or auditing purposes.

select
  *
from
  zoom_role
where
  id = '1';
-- Owner role

select
  *
from
  zoom_role
where
  id = '1';
-- Owner role

Get privileges for each role

Explore which privileges are assigned to each role within the Zoom platform to understand user permissions and rights. This can help in managing user access and ensuring appropriate security measures are in place.

select
  r.id,
  r.name,
  p
from
  zoom_role as r,
  jsonb_array_elements(r.privileges) as p
order by
  r.name,
  p;

select
  r.id,
  r.name,
  p.value as p
from
  zoom_role as r,
  json_each(r.privileges) as p
order by
  r.name,
  p.value;

Find all roles with permission to edit account settings

Identify roles that have the authority to modify account settings, with the intent of understanding which roles have this level of access and how many members each role contains.

select
  id,
  name,
  total_members
from
  zoom_role
where
  privileges ? 'AccountSetting:Edit'
order by
  total_members;

select
  id,
  name,
  total_members
from
  zoom_role
where
  json_extract(privileges, '$."AccountSetting:Edit"') is not null
order by
  total_members;

Schema for zoom_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
account_id	text		Zoom account ID.
description	text		Role description.
id	text	=	Role ID.
name	text		Role name.
privileges	jsonb		Privileges assigned to the role.
sub_account_privileges	jsonb		Privileges for management of sub-accounts.
total_members	bigint		Total number of members in the role.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- zoom

You can pass the configuration to the command with the --config argument:

steampipe_export_zoom --config '<your_config>' zoom_role