| From: | ohp(at)pyrenet(dot)fr |
|---|---|
| To: | pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_stat_activity |
| Date: | 2003-07-07 15:39:44 |
| Message-ID: | Pine.UW2.4.53.0307071736260.25886@server.pyrenet.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2003-07-07 17:04:14 | Re: pg_autovacuum bug and feature request |
| Previous Message | Tom Lane | 2003-07-07 13:07:54 | Re: OSF build broken |