From: | Greg Williamson <gwilliamson39(at)yahoo(dot)com> |
---|---|
To: | |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: allow a user to see current_query in pg_stat_activity in 8.4 |
Date: | 2012-12-14 03:34:34 |
Message-ID: | 1355456074.36965.YahooMailNeo@web125901.mail.ne1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Tom --
>Greg Williamson <gwilliamson39(at)yahoo(dot)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.
Thanks for the swi8ft answer even if wasn't the one I was hoping for. ;-}
Another solution suggests itself then ... thanks!
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | dmp | 2012-12-14 15:56:48 | Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc) |
Previous Message | Haifeng Liu | 2012-12-14 03:29:25 | Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc) |