Englich version below
Utilisateur de supervision sur PostgreSQL
Pour pouvoir faire de la supervision sur une instance PostgreSQL, il est nécessaire de créer un utilisateur de supervision à permissions restreintes.
Il faut se connecter au serveur Mariadb :
psql "host=host port=5432 dbname=db [email protected] sslmode=require"
Pour créer le nouvel utilisateur :
CREATE USER user_readonly LOGIN PASSWORD 'userpassword';
Lui affecter les permissions en lecture :
GRANT CONNECT ON DATABASE my_database TO user_readonly;
GRANT USAGE ON SCHEMA public TO user_readonly;
GRANT SELECT ON ALL TABLES IN schema public TO user_readonly;
User for PostgreSQL monitoring
To monitor an instance of MariaDB, one ought to create a user with just enough permissions to perform said monitoring.
First we connect to the instance:
psql "host=host port=5432 dbname=db [email protected] sslmode=require"
We create the user:
CREATE USER user_readonly LOGIN PASSWORD 'userpassword';
Add read permissions to the user:
GRANT CONNECT ON DATABASE my_database TO user_readonly;
GRANT USAGE ON SCHEMA public TO user_readonly;
GRANT SELECT ON ALL TABLES IN schema public TO user_readonly;