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!