Prevent ALTER USER f RESET ALL from removing the settings that were put there
Alvaro Herrera <alvherre@alvh.no-ip.org>
Prevent ALTER USER f RESET ALL from removing the settings that were put there by a superuser -- "ALTER USER f RESET setting" already disallows removing such a setting. Apply the same treatment to ALTER DATABASE d RESET ALL when run by a database owner that's not superuser.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/dbcommands.c | modified | +25 −4 |
| src/backend/commands/user.c | modified | +25 −4 |
| src/backend/utils/misc/guc.c | modified | +82 −1 |
| src/include/utils/guc.h | modified | +2 −1 |