Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

permissions on system catalogs for non-superuser?



Hi List;

we have some monitoring/alert scripts which run sql against the database 
(8.1.4) as a non-superuser. The problem is I get <insufficient privilege> 
when trying to access current_query from pg_stat_activity. 

I ran these grant statements but still no joy:
grant select on pg_stat_activity to monitor_user;
grant select on pg_database to monitor_user;


Here's what I get while logged into psql as monitor_user:

select procpid, current_query from pg_stat_activity;
 procpid |      current_query
---------+--------------------------
   24589 | <IDLE>
   24601 | <insufficient privilege>
   24600 | <insufficient privilege>
   24598 | <insufficient privilege>
   24596 | <insufficient privilege>
   24594 | <insufficient privilege>
   24367 | <insufficient privilege>
   24511 | <insufficient privilege> 


Thanks in advance

/Kevin



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group