Re: [GENERAL] grant select on pg_stat_activity

2016-03-21 Thread Adrian Klaver
On 03/21/2016 07:15 AM, Vick Khera wrote: On Fri, Mar 18, 2016 at 5:46 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: They should be able to, see below. If that is not your case, then more information is needed. You can see your own queries, however non-superuser will not

Re: [GENERAL] grant select on pg_stat_activity

2016-03-21 Thread Vick Khera
On Fri, Mar 18, 2016 at 5:46 PM, Adrian Klaver wrote: > They should be able to, see below. If that is not your case, then more > information is needed. > You can see your own queries, however non-superuser will not see the query for other users. You will be able to see the other info, though. I

Re: [GENERAL] grant select on pg_stat_activity

2016-03-19 Thread Adrian Klaver
On 03/18/2016 01:09 PM, avi Singh wrote: Guys Whats the best way to grant select on pg_stat_activity so that non super user can access this view. They should be able to, see below. If that is not your case, then more information is needed. guest@test=> select current_user; current_