Tom --
>Greg Williamson <gwilliamson39@yahoo.com> writes:
>> We want to create a role used by a monitor to check for "<IDLE> in Transaction" with the most restrictive
permissionswe 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
tobe 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