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 <wi...@wiwwo.com> napisał(a): > 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! >
