Difference between revisions of "Pg monitor"
Jump to navigation
Jump to search
(Created page with "* <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<...") |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | {{lc}} | ||
* <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]], | ||
| − | {{postgreSQL users}} | + | * [[Read only]]: [[PostgreSQL read only user]] |
| + | |||
| + | == See also == | ||
| + | * {{postgreSQL users}} | ||
| + | * {{GRANT}} | ||
| + | |||
| + | [[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:
