Table: doppler_user - Query Doppler Users using SQL

Doppler is a universal secrets manager that helps you to manage and securely access secrets, such as database credentials, API keys, and tokens. It provides an intuitive interface for managing secrets across multiple environments and cloud platforms. Doppler ensures that secrets are automatically synced and updated across all applications, services, and users.

Table Usage Guide

The doppler_user table provides insights into user accounts within Doppler. As a security engineer, explore user-specific details through this table, including user roles, access rights, and associated metadata. Utilize it to uncover information about users, such as their assigned roles, the access rights they have, and the verification of their access controls.

Examples

Basic info

Explore which users have access to your Doppler workspace, including when they were created and their associated email and username. This can help you manage user access and understand who has permissions within your workspace.

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user;

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user;

List users that are created in the last 30 days

Explore which users have been added to your system in the past month. This can help you keep track of your growing user base and understand recent changes in your user demographics.

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user
where
  created_at >= now() - interval '30 day';

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user
where
  created_at >= datetime('now', '-30 day');

List users with owner access

Discover the users who have owner access, which is crucial for understanding the distribution of administrative privileges in your workplace. This can be particularly useful in audits or when reevaluating permission structures.

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user
where
  access = 'owner';

select
  id,
  name,
  email,
  username,
  created_at,
  access,
  workplace_name
from
  doppler_user
where
  access = 'owner';

Schema for doppler_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
access	text		The access level of the user.
created_at	timestamp with time zone		The time when the project was created.
email	text		The user's email address.
id	text	=	The ID of the user.
name	text		The user's name.
profile_image_url	text		The user's profile image URL.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		The name of the workplace.
username	text		The user's username.
workplace_id	text	=, !=, ~~, ~~, !~~, !~~	The ID of the workplace.
workplace_name	text		Title of the resource.

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

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

steampipe_export_doppler --config '<your_config>' doppler_user