Re: ALTER USER SET log_* not allowed...

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Sure.  There is a workaround for that though, which is to provide a
>> SECURITY DEFINER function for the app to call that will adjust the
>> logging level for it, rather than trying to do the SET directly in
>> unprivileged code.

> But if they go that way can it done securely, turned on and off?

Why not?  You can put whatever restrictions you like in such a function.

It'd certainly be more "secure" than the existing USERLIMIT behavior,
because the DBA can decide exactly what policy he wants and code it
into the function he gives his users (maybe even multiple functions for
different users).  USERLIMIT effectively dictates to the DBA what will
be allowed.

            regards, tom lane