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.

			regards, tom lane

Responses

• Re: ALTER ROLE/DATABASE RESET ALL versus security at 2009-11-14 02:01:43 from Bernd Helmle
• Re: ALTER ROLE/DATABASE RESET ALL versus security at 2009-11-15 19:34:06 from Alvaro Herrera
• Re: ALTER ROLE/DATABASE RESET ALL versus security at 2010-02-19 18:22:22 from Alvaro Herrera

pgsql-hackers by date

Next:	From: James Mansion	Date: 2009-11-14 00:14:28
	Subject: Re: Listen / Notify rewrite
Previous:	From: Alvaro Herrera	Date: 2009-11-14 00:05:14
	Subject: Re: tsearch parser inefficiency if text includes urls or emails - new version