Greg Williamson <gwilliamso...@yahoo.com> 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.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
