Re: pg_stat_activity

Hi ivan,

Sounds like a plan, I'll try it, many thanks!!

Still, shouldn't there be a view like this : select * from db_activity
wher it returns stat_activity only for current database??

Regaerds
On Mon, 7 Jul 2003, ivan wrote:

> Date: Mon, 7 Jul 2003 21:21:32 +0200 (CEST)
> From: ivan <iv(at)psycho(dot)pl>
> To: ohp(at)pyrenet(dot)fr
> Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
> Subject: Re: [HACKERS] pg_stat_activity
>
>
> You can create function with security definer as super user
> sth like this
> create or replace function func () returns setof pg_stat_activity as '
> select * from pg_stat_activity ; ' language SQL SECURITY DEFINER;
>
> and if you want to se only query of session user you need to replace
> * to columns from view pg_stat_activity , and to column query
> you need to use CASE , when username == SESSION_USER : cur_query,
> else null;
>
> On Mon, 7 Jul 2003 ohp(at)pyrenet(dot)fr wrote:
>
> > 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)
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
>

--
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)