Limiting user from changing its own attributes
От
Sameer Kumar
Тема
Limiting user from changing its own attributes
Дата
Msg-id
CADp-Sm7GYyZZOYbqUBq22vzMxOhDvMrHdLb7OKYv4_hfVGKaHQ@mail.gmail.com
Список
Дерево обсуждения
Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes "David G. Johnston" <david.g.johnston@gmail.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes "David G. Johnston" <david.g.johnston@gmail.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes "David G. Johnston" <david.g.johnston@gmail.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
Re: Limiting user from changing its own attributes "David G. Johnston" <david.g.johnston@gmail.com>
Re: Limiting user from changing its own attributes Sameer Kumar <sameer.kumar@ashnik.com>
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 -
psql -U user1 -d postgres
postgres=# alter user user user1 set work_mem to '1024000';
ALTER ROLE
postgres=#
Is there a way I restrict this behavior? or atleast put a restriction on the certain parameters e.g. work_mem to be not set to too high?
regards
Sameer
В списке pgsql-general по дате отправления