Re: [GENERAL] disallow SET WORK_MEM

2011-12-05 Thread Tom Lane
Bruce Momjian writes: > Andreas Kretschmer wrote: >> is it possible to disallow "set work_mem to ..." for regular >> (non-superuser) users? > We have discussed it and might offer that ability some day, but > currently there is no way to do that. There are so many ways to mess > things up with a

Re: [GENERAL] disallow SET WORK_MEM

2011-12-05 Thread Bruce Momjian
Andreas Kretschmer wrote: > Hi @list, > > is it possible to disallow "set work_mem to ..." for regular > (non-superuser) users? > > Background: a shared database server with multiple users. We have discussed it and might offer that ability some day, but currently there is no way to do that. The

[GENERAL] disallow SET WORK_MEM

2011-12-05 Thread Andreas Kretschmer
Hi @list, is it possible to disallow "set work_mem to ..." for regular (non-superuser) users? Background: a shared database server with multiple users. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (