Re: who can view pg_stat_activity?

sweet! :)

--cnemelka

On Wed, Feb 7, 2018 at 10:31 AM, Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:

> Thank you for your prompt answer Shreeyansh
>
> I granted all privileges to the pg_stat_activity view to the newmail
> account and still get this result when trying to access:
>
> select * from pg_stat_activity limit 4;
> datid | datname | pid | usesysid | usename | application_name
> | client_addr | client_hostname | client_port | backend_start | xact_start
> | query_start | state_change | waiting | state | backend_xid | backend_xmin
> | query
> -------+------------------+-------+----------+---------+----
> --------------+-------------+-----------------+-------------
> +---------------+------------+-------------+--------------+-
> --------+-------+-------------+--------------+--------------------------
> 16459 | prime_production | 6133 | 16395 | prime |
> | | | | |
> | | | | | |
> | <insufficient privilege>
> 16459 | prime_production | 57677 | 16395 | prime |
> | | | | |
> | | | | | |
> | <insufficient privilege>
> 16459 | prime_production | 5806 | 16395 | prime |
> | | | | |
> | | | | | |
> | <insufficient privilege>
> 16459 | prime_production | 17532 | 16395 | prime |
> | | | | |
> | | | | | |
> | <insufficient privilege>
>
>
>
>
> On Wed, Feb 7, 2018 at 12:17 PM, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> wrote:
>
>> Hi Mark Steben,
>>
>> There is no superuser required to view pg_stat_activity, a normal user
>> can also view or access.
>>
>>
>> <http://www.shreeyansh.com>
>>
>> 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/>
>>
>>
>>
>
>
> --
> *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+%3Chttps://maps.google.com/?q%3D95D%2BAshley%2BAve.%2BWest%2BSpringfield,%2BMA%2B01089%26entry%3Dgmail%26source%3Dg%3E&entry=gmail&source=g>
> West Springfield, MA 01089
> <https://maps.google.com/?q=95D+Ashley+Ave.+West+Springfield,+MA+01089+%3Chttps://maps.google.com/?q%3D95D%2BAshley%2BAve.%2BWest%2BSpringfield,%2BMA%2B01089%26entry%3Dgmail%26source%3Dg%3E&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/>