| From: | Mateusz Henicz <mateuszhenicz(at)gmail(dot)com> |
|---|---|
| To: | Wiwwo Staff <wiwwo(at)wiwwo(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Monitoring-only role |
| Date: | 2022-12-06 12:43:26 |
| Message-ID: | CAN6i3YMKoTGgpPrzUC3h0ytCkSxVybndZmduTZwKSK_j_v0S-w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)wiwwo(dot)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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shashidhar Reddy | 2022-12-06 13:52:50 | Re: plpgsql_check_function issue after upgrade |
| Previous Message | Wiwwo Staff | 2022-12-06 12:37:37 | Monitoring-only role |