grants on pg_stats_activity

Hi all,

I'm trying to monitor databases with munin. For security reasons I guess it
is better to create a specialized user "munin" or like that and grant it
only the necessary rights: no superuser rights, nor write access on my
applications databases.

My problem is, this user cannot access to info of pg_stat_activity view. It
can only count the entries, but I would want to monitor waiting, and
IDLE/IDLE in transaction connections.
Is that possible ?

As seen in an old post, I tried grant select on pg_stat_activity and
pg_authid, to no avail.

The PostgreSQL version I use is the 8.3. But I will need it also on 8.4

Regards,

--
JC
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!