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

Hub

Plugins Mods Docs Home

Plugins

francois2metz/scalingo

steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_database_user

List of users of a database

You must specify app_name and addon_id in a where clause in order to use this table.

Examples

List users of a database

select
  name,
  read_only
from
  scalingo_database_user
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000';

List readonly users

select
  name,
  read_only
from
  scalingo_database_user
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000'
  and read_only;

Schema for scalingo_database_user

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
addon_id	text	=	ID of the addon.
app_name	text	=	Name of the app.
name	text		Name of the user.
protected	boolean		True if the user is protected.
read_only	boolean		True if the user is readonly.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.