Re: [GENERAL] about privileges on pg_stat_activity columns

2008-12-04 Thread Jaime Casanova
On Thu, Dec 4, 2008 at 4:02 AM, Richard Huxton <[EMAIL PROTECTED]> wrote: > Jaime Casanova wrote: >> >> we created an user to him and give him privileges to pg_locks and >> pg_stat_activity (and the functions pg_stat_activity is calling) but >> still he see the columns that comes from the functions

Re: [GENERAL] about privileges on pg_stat_activity columns

2008-12-04 Thread Richard Huxton
Jaime Casanova wrote: > Hi, > > there is an auditor that want to monitor our database activity to see > the session and the ip they come from, if they are waiting and so > on... pg_stat_activity and pg_locks views come to my mind... > > we created an user to him and give him privileges to pg_lock