Monitoring-only role
Started by Wiwwo Staffover 3 years ago2 messagesgeneral
Hi there!
Is there (a way to have) a "monitoring only" role in PG?
This role should have access to stat views only,maybe something more, but
no access to data whatsoever.
Tnx!
Re: Monitoring-only role
Hey,
There is pg_monitor role. I can "Read/execute various monitoring views and
functions. This role is a member of pg_read_all_settings, pg_read_all_stats
and pg_stat_scan_tables."
https://www.postgresql.org/docs/14/predefined-roles.html
Cheers,
Mateusz
wt., 6 gru 2022 o 13:37 Wiwwo Staff <wiwwo@wiwwo.com> napisał(a):
Show quoted text
Hi there!
Is there (a way to have) a "monitoring only" role in PG?
This role should have access to stat views only,maybe something more, but
no access to data whatsoever.Tnx!