Documentation for Server 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;