Re: SET variable - Permission issues

Kevin Grittner wrote:
> Joe Conway <mail@joeconway.com> wrote:
> > On 10/10/2011 01:52 PM, Gurjeet Singh wrote:
>  
> >> ALTER USER novice SET MIN_VAL OF statement_timeout TO '1';
> >> -- So that the user cannot turn off the timeout
> >> 
> >> ALTER DATABASE super_reliable SET ENUM_VALS OF synchronous_commit
> >>   TO 'on';
> >> -- So that the user cannot change the synchronicity of
> >> transactions against this database.
> > 
> > I like this better than GRANT/REVOKE on SET.
>  
> +1
>  
> I would really like a way to prevent normal users from switching
> from the default transaction isolation level I set.  This seems like
> a good way to do that.  Putting sane bounds on some other settings,
> more to protect against the accidental bad settings than malicious
> mischief, would be a good thing, too.

Is this a TODO?  We might not want to make work_mem SUSET, but it would
allow administrators to control this.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +