steampipe 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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addon_idtext=ID of the addon.
app_nametext=Name of the app.
nametextName of the user.
protectedbooleanTrue if the user is protected.
read_onlybooleanTrue if the user is readonly.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.