Difference between revisions of "Pg monitor"
Jump to navigation
Jump to search
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* <code>[[pg_monitor]]</code> Read/execute various monitoring views and functions. This role is a member of <code>[[pg_read_all_settings]]</code>, <code>[[pg_read_all_stats]]</code> and <code>[[pg_stat_scan_tables]]</code>. | * <code>[[pg_monitor]]</code> Read/execute various monitoring views and functions. This role is a member of <code>[[pg_read_all_settings]]</code>, <code>[[pg_read_all_stats]]</code> and <code>[[pg_stat_scan_tables]]</code>. | ||
| + | |||
| + | GRANT [[pg_read_all_data]], [[pg_monitor]], | ||
| + | |||
| + | * [[Read only]]: [[PostgreSQL read only user]] | ||
== See also == | == See also == | ||
* {{postgreSQL users}} | * {{postgreSQL users}} | ||
| + | * {{GRANT}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 16:14, 20 September 2024
pg_monitorRead/execute various monitoring views and functions. This role is a member ofpg_read_all_settings,pg_read_all_statsandpg_stat_scan_tables.
GRANT pg_read_all_data, pg_monitor,
See also[edit]
- PostgreSQL users, predefined roles:
pg_read_all_data, pg_monitor,create role,.pgpass, PostgreSQL read only user GRANT,\ddp,GRANT USAGE,GRANT ALL PRIVILEGES,GRANT SELECT, View GRANTs on Redshift,has_table_privilege,has_schema_privilege,HAS_DATABASE_PRIVILEGE,SCHEMA, Privileges,GRANT EXECUTE
Advertising:
