Re: grant permissions to set variable?

Vivek Khera wrote:
> I want to do some debugging on an app, and I'd like to set on a
> per-connection basis "set log_min_duration_statement = 10;"  Obviously
> since I'm not super user I get permission denied.
>
> Is there some GRANT I can grant to the user in question to allow this?
> I don't really want to do it globally or for all connections by that
> user, both of which are easy to do

Could you handle it with a security=definer function?

--
   Richard Huxton
   Archonet Ltd