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
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
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_locks and
pg_stat_activity (and the func
