From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: who can view pg_stat_activity? |
Date: | 2018-02-07 17:17:06 |
Message-ID: | CAGDYbUNNYGRzSH0fCaTPa21zzF0PkxVi_iQnZ=ZHEs=Dvy91GQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Mark Steben,
There is no superuser required to view pg_stat_activity, a normal user can
also view or access.
On Wed, Feb 7, 2018 at 10:27 PM, Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:
> Good morning,
>
> We currently run postgres 9.4. The only way to view the pg_stat_activity
> view that I can see is that you must be a superuser. I couldn't find
> anything in the documentation to confirm or refute this. Could you please
> confirm if this is true or if not, what privileges are required?
>
> Thank you for your time.
>
>
> --
> *Mark Steben*
> Database Administrator
> @utoRevenue <http://www.autorevenue.com/> | Autobase
> <http://www.autobase.net/>
> CRM division of Dominion Dealer Solutions
> 95D Ashley Ave.
> <https://maps.google.com/?q=95D+Ashley+Ave.+West+Springfield,+MA+01089&entry=gmail&source=g>
> West Springfield, MA 01089
> <https://maps.google.com/?q=95D+Ashley+Ave.+West+Springfield,+MA+01089&entry=gmail&source=g>
> t: 413.327-3045
> f: 413.383-9567
>
> www.fb.com/DominionDealerSolutions
> www.twitter.com/DominionDealer
> www.drivedominion.com <http://www.autorevenue.com/>
>
> <http://autobasedigital.net/marketing/DD12_sig.jpg>
>
>
>
>
> <http://www.drivedominion.com/transform-your-vue/>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Steben | 2018-02-07 17:31:17 | Re: who can view pg_stat_activity? |
Previous Message | Mark Steben | 2018-02-07 16:57:35 | who can view pg_stat_activity? |