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

2015-05-05 Thread Sameer Kumar
On Tue, May 5, 2015 at 1:44 PM David G. Johnston david.g.johns...@gmail.com wrote: On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar sameer.ku...@ashnik.com 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

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

2015-05-04 Thread Sameer Kumar
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 sameer.ku...@ashnik.com wrote: On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby jim.na...@bluetreble.com wrote: No. I suspect

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

2015-05-04 Thread David G. Johnston
On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar sameer.ku...@ashnik.com 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 sameer.ku...@ashnik.com wrote: On Mon,

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

2015-04-13 Thread David G. Johnston
On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar sameer.ku...@ashnik.com wrote: On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby jim.na...@bluetreble.com 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

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

2015-04-12 Thread Jim Nasby
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

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

2015-04-12 Thread Sameer Kumar
On Mon, 13 Apr 2015 11:35 Jim Nasby 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 know of. I guess that upper bound column is more of the limit

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

2015-04-12 Thread Jim Nasby
On 4/12/15 11:55 PM, Sameer Kumar wrote: On Mon, 13 Apr 2015 11:35 Jim Nasby jim.na...@bluetreble.com 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

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

2015-04-12 Thread Sameer Kumar
On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby jim.na...@bluetreble.com wrote: On 4/12/15 11:55 PM, Sameer Kumar wrote: On Mon, 13 Apr 2015 11:35 Jim Nasby jim.na...@bluetreble.com mailto:jim.na...@bluetreble.com wrote: On 4/11/15 4:11 PM, Sameer Kumar wrote: Pg_settings

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

2015-04-11 Thread Sameer Kumar
On Sat, 11 Apr 2015 16:05 David G. Johnston david.g.johns...@gmail.com wrote: On Friday, April 10, 2015, Sameer Kumar sameer.ku...@ashnik.com 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

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

2015-04-11 Thread Sameer Kumar
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 sameer.ku...@ashnik.com 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 -

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

2015-04-11 Thread David G. Johnston
On Friday, April 10, 2015, Sameer Kumar sameer.ku...@ashnik.com wrote: On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston david.g.johns...@gmail.com javascript:_e(%7B%7D,'cvml','david.g.johns...@gmail.com'); wrote: On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar sameer.ku...@ashnik.com