Documentation forServer Configuration Monitor

Permissions required to monitor PostgreSQL Essentials in SCM

Most of the elements in the built-in profile for PostgreSQL Essentials can be monitored using the default public login (see Create role). Some SQL elements require additional permissions.

Element Permissions required

Server settings

Create role

Configuration files

Grant select on pg_file settings to scmtest
Database roles Create role
Databases Create role
Authentication rules Grant select on pg_hba_file to scmtest
Time zones Create role
Tablespaces Create role
Collations Create role
Publications Create role
Subscriptions Grant select on pg_subscription to scmtest
Attributes Create role
Indexes Create role
Procedures and functions Create role
Tables Create role
Users Create role
Views Create role

PostgreSQL Essentials permissions

Permission Command

Create role

CREATE ROLE scmtest LOGIN PASSWORD 'Password1' NOINHERIT NOSUPERUSER NOCREATEDB NOCREATEROLE;

Grant select on pg_file settings to scmtest

GRANT SELECT ON pg_file_settings TO scmtest;
GRANT EXECUTE ON FUNCTION pg_show_all_file_settings TO scmtest;
Grant select on pg_hba_file to scmtest
GRANT SELECT ON pg_hba_file_rules TO scmtest;
GRANT EXECUTE ON FUNCTION pg_hba_file_rules TO scmtest;
Grant select on pg_subscription to scmtest
GRANT SELECT ON pg_subscription TO scmtest;