Difference between revisions of "Pg monitor"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 5: | Line 5: | ||
GRANT [[pg_read_all_data]], [[pg_monitor]], | GRANT [[pg_read_all_data]], [[pg_monitor]], | ||
− | * [[Read only]] | + | * [[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_monitor
Read/execute various monitoring views and functions. This role is a member ofpg_read_all_settings
,pg_read_all_stats
andpg_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: