Hi every one, Is there a way for joe user (not superuser) to see current query on HIS database on pg_stat_activity.
ISTM that only superuser can see current query for all. As fr security, it doesn't seem right that select * from pg_stat_activity shows all databases. What do you think? -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) 6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
