Re: [GENERAL] Limiting user from changing its own attributes

On Tue, May 5, 2015 at 1:44 PM David G. Johnston wrote: > On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar > wrote: > >> Sorry about the long silence on this. >> >> On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >>> On Sun, Apr 12, 2015 at 10:23 PM, Sam

Re: [GENERAL] Limiting user from changing its own attributes

On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar wrote: > Sorry about the long silence on this. > > On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar >> wrote: >> >>> On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby

Re: [GENERAL] Limiting user from changing its own attributes

Sorry about the long silence on this. On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar > wrote: > >> On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby >> wrote: >> > >>> No. I suspect the community would support at l

Re: [GENERAL] Limiting user from changing its own attributes

On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar wrote: > > On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby > wrote: > >> >> No. I suspect the community would support at least a hook for GUC >> changes, if not a full-on permissions system. A hook would make it >> fairly easy to add event trigger support

Re: [GENERAL] Limiting user from changing its own attributes

On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby wrote: > On 4/12/15 11:55 PM, Sameer Kumar wrote: > > > > On Mon, 13 Apr 2015 11:35 Jim Nasby > > wrote: > > > > On 4/11/15 4:11 PM, Sameer Kumar wrote: > > > Pg_settings currently has an upper bound column -

Re: [GENERAL] Limiting user from changing its own attributes

On 4/12/15 11:55 PM, Sameer Kumar wrote: On Mon, 13 Apr 2015 11:35 Jim Nasby mailto:jim.na...@bluetreble.com>> wrote: On 4/11/15 4:11 PM, Sameer Kumar wrote: > Pg_settings currently has an upper bound column - though it is a > view and that value cannot be changed that I k

Re: [GENERAL] Limiting user from changing its own attributes

On Mon, 13 Apr 2015 11:35 Jim Nasby wrote: On 4/11/15 4:11 PM, Sameer Kumar wrote: > Pg_settings currently has an upper bound column - though it is a > view and that value cannot be changed that I know of. > > > I guess that upper bound column is more of the limit that is imposed by > sy

Re: [GENERAL] Limiting user from changing its own attributes

On 4/11/15 4:11 PM, Sameer Kumar wrote: Pg_settings currently has an upper bound column - though it is a view and that value cannot be changed that I know of. I guess that upper bound column is more of the limit that is imposed by system which you can have for a parameter i.e. the syste

Re: [GENERAL] Limiting user from changing its own attributes

On Sat, 11 Apr 2015 16:05 David G. Johnston wrote: On Friday, April 10, 2015, Sameer Kumar wrote: On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston < david.g.johns...@gmail.com> wrote: On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar wrote: Yes either an upper bound to which users can set

Re: [GENERAL] Limiting user from changing its own attributes

On Friday, April 10, 2015, Sameer Kumar wrote: > On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston < > david.g.johns...@gmail.com > > wrote: > >> On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar > > wrote: >> > > Yes either an upper bound to which users can set their own values to. > > >> Upper is

Re: [GENERAL] Limiting user from changing its own attributes

On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar > wrote: > >> Hi, >> >> In PostgreSQL a user can alter itself to change its user level >> parameters. e.g. I can alter the user to change work_mem - >> >> >> psq