Search Postgresql Archives

Re: Privilege for seeing queries using pg_stat_get_backend_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Marc Munro <marc@xxxxxxxxxxxx>
Subject: Re: Privilege for seeing queries using pg_stat_get_backend_activity
From: Michael Fuhr <mike@xxxxxxxx>
Date: Thu, 19 Jan 2006 10:42:19 -0700
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <1137691032.18509.6.camel@xxxxxxxxxxxx>
References: <20060117033914.4ECC5701490@xxxxxxxxxxx> <1137691032.18509.6.camel@xxxxxxxxxxxx>

On Thu, Jan 19, 2006 at 09:17:12AM -0800, Marc Munro wrote:
> I've tried tricks with security definer functions but this does not help
> as pg_stat_get_backend_activity explicitly checks for the caller being a
> superuser.

Works here.  Could you post an example?

-- 
Michael Fuhr

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Privilege for seeing queries using pg_stat_get_backend_activity
  - From: Marc Munro

Prev by Date: [no subject]
Next by Date: Re: create plperlu langage fails
Previous by thread: Re: Privilege for seeing queries using
Next by thread: [no subject]
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux