Re: ALTER ROLE/DATABASE RESET ALL versus security

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: ALTER ROLE/DATABASE RESET ALL versus security
Дата
Msg-id 201002270338.o1R3cnB28008@momjian.us
обсуждение исходный текст
Ответ на Re: ALTER ROLE/DATABASE RESET ALL versus security  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: ALTER ROLE/DATABASE RESET ALL versus security  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> Tom Lane wrote:
> > Alvaro Herrera <alvherre@commandprompt.com> writes:
> > > Tom Lane wrote:
> > >> It looks to me like the code in AlterSetting() will allow an ordinary
> > >> user to blow away all settings for himself.  Even those that are for
> > >> SUSET variables and were presumably set for him by a superuser.  Isn't
> > >> this a security hole?  I would expect that an unprivileged user should
> > >> not be able to change such settings, not even to the extent of
> > >> reverting to the installation-wide default.
> > 
> > > Yes, it is, but this is not a new hole.  This works just fine in 8.4
> > > too:
> > 
> > So I'd argue for changing it in 8.4 too.
> 
> Understood.  I'm starting to look at what this requires.

Any progress on this?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.comPG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do + If your life is a hard
drive,Christ can be your backup. +
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Lock Wait Statistics (next commitfest)
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Hot Standby query cancellation and Streaming Replication integration