[ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Greg Williamson
This seems like a question whose answer must be right in front of me, but I am not seeing it. We want to create a role used by a monitor to check for " 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

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Tom Lane
Greg Williamson writes: > We want to create a role used by a monitor to check for " 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 b

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Greg Williamson
Tom -- >Greg Williamson writes: >> We want to create a role used by a monitor to check for " 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 tabhle

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-26 Thread ynux
Hi. Your question was: >> We want to create a role used by a monitor to check for " 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 t

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-26 Thread Robert Treat
On Fri, Dec 21, 2012 at 8:12 AM, ynux wrote: > Hi. > Your question was: > >>> We want to create a role used by a monitor to check for " 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