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 по дате отправления
От: Vasudevan, Ramya
Дата:
От: David G. Johnston
Дата:
FAQ