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
