Table: auth0_role_permission - Query Auth0 Role Permissions using SQL

Auth0 Role Permission is a feature within Auth0's Role-Based Access Control (RBAC) that allows the assignment of permissions to roles. It provides a structured way to manage permissions for various roles, including users, groups, and applications. Auth0 Role Permission helps maintain the security and integrity of your resources by ensuring only authorized access.

Table Usage Guide

The auth0_role_permission table provides insights into role permissions within Auth0's Role-Based Access Control (RBAC). As a security analyst, explore permission-specific details through this table, including the roles assigned, associated resources, and access levels. Utilize it to uncover information about permissions, such as those with broad access, the relationships between roles and permissions, and the verification of access controls.

Examples

List all the permissions assigned to a role

Discover the segments that have been granted specific permissions within a designated role. This is particularly useful in managing user access and ensuring appropriate security measures are in place.

select
  permission_name,
  description,
  resource_server_name
from
  auth0_role_permission
where
  role_id = 'rol_VkaG05dncCpNN3oI'
order by
  resource_server_name,
  permission_name;

select
  permission_name,
  description,
  resource_server_name
from
  auth0_role_permission
where
  role_id = 'rol_VkaG05dncCpNN3oI'
order by
  resource_server_name,
  permission_name;

List roles with assigned permission of a resource server

Determine the areas in which specific roles are assigned permissions within a particular resource server. This can be useful for managing access control and ensuring appropriate permissions are allocated.

select
  r.name
from
  auth0_role r
  join auth0_role_permission p on p.role_id = r.id
where
  p.resource_server_name = 'novel-mutt'
group by
  r.name
order by
  r.name;

select
  r.name
from
  auth0_role r
  join auth0_role_permission p on p.role_id = r.id
where
  p.resource_server_name = 'novel-mutt'
group by
  r.name
order by
  r.name;

Schema for auth0_role_permission

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
description	text		The description of the permission.
permission_name	text		The name of the permission.
resource_server_identifier	text		The resource server that the permission is attached to.
resource_server_name	text		The name of the resource server.
role_id	text	=	A unique ID for 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)" -- auth0

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

steampipe_export_auth0 --config '<your_config>' auth0_role_permission