Table: cloudflare_account_role - Query Cloudflare Account Roles using SQL

Cloudflare Account Roles are a part of Cloudflare's user management system that allows you to control who has access to your Cloudflare account and what they can do. Each role has a predefined set of permissions that determine what actions a user can take and what information they can view within your account. The roles system is designed to provide flexibility and control over your account's security.

Table Usage Guide

The cloudflare_account_role table provides insights into the roles within Cloudflare's user management system. As a security analyst, you can explore role-specific details through this table, including permissions and associated metadata. Utilize it to uncover information about roles, such as those with specific permissions, the roles assigned to specific users, and to verify the security measures in place for your account.

Examples

Basic info

Explore which roles are associated with different accounts on Cloudflare, enabling you to manage and organize permissions effectively.

select
  name,
  id,
  account_id,
from
  cloudflare_account_role;

select
  name,
  id,
  account_id
from
  cloudflare_account_role;

Schema for cloudflare_account_role

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=	Specifies the account id where the role is created at.
description	text		A description of the role.
id	text	=	Specifies the Role identifier.
name	text		Specifies the name of the role.
permissions	jsonb		A list of permissions attached with the role.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
user_id	text	=, !=, ~~, ~~, !~~, !~~	ID of the current user.

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)" -- cloudflare

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

steampipe_export_cloudflare --config '<your_config>' cloudflare_account_role