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 |