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, e.g. connection_name.
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.