Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitoring-only role - Mailing list pgsql-general

From Mateusz Henicz
Subject Re: Monitoring-only role
Date
Msg-id CAN6i3YMKoTGgpPrzUC3h0ytCkSxVybndZmduTZwKSK_j_v0S-w@mail.gmail.com
Whole thread Raw
In response to Monitoring-only role  (Wiwwo Staff <wiwwo@wiwwo.com>)
List pgsql-general
Tree view
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."

Cheers,
Mateusz

wt., 6 gru 2022 o 13:37 Wiwwo Staff <wiwwo@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!

pgsql-general by date:

Previous
From: Wiwwo Staff
Date:
Subject: Monitoring-only role
Next
From: shashidhar Reddy
Date:
Subject: Re: plpgsql_check_function issue after upgrade