pg_stat_activity - Mailing list pgsql-hackers

From ohp@pyrenet.fr
Subject pg_stat_activity
Date
Msg-id Pine.UW2.4.53.0307071736260.25886@server.pyrenet.fr
Whole thread Raw
Responses Re: pg_stat_activity  (ivan <iv@psycho.pl>)
List 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@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OSF build broken
Next
From: Carlos Guzman Alvarez
Date:
Subject: CREATE DATABASE command in Extended Query mode of 3.0 protocol