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 functions pg_stat_activity is calling) but
still he see the columns that comes from the functions as null... is
there a way to give him access to that data without give him
superuser?
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157