Tom -- >Greg Williamson <gwilliamson39@xxxxxxxxx> writes: >> We want to create a role used by a monitor to check for "<IDLE> in Transaction" with the most restrictive permissions we can on a 8.4.13 instance. > >> The user has been granted connect privilege to the database and some limited permissions to user tabhles that need to be monitored. But pg_stat_activity shows only "<insufficient privilege>" > >Yup. You can only see the query of another session if (1) you are a >superuser, or (2) you are the same user the other session is logged in >as. Table permissions have nothing to do with this. Thanks for the swi8ft answer even if wasn't the one I was hoping for. ;-} Another solution suggests itself then ... thanks! Greg -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
