Skip site navigation (1) Skip section navigation (2)

pgsql: Prevent ALTER USER f RESET ALL from removing the settings that

From: alvherre(at)postgresql(dot)org (Alvaro Herrera)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prevent ALTER USER f RESET ALL from removing the settings that
Date: 2010-03-25 14:44:51
Message-ID: 20100325144451.719A17541D0@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
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.

Tags:
----
REL8_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/commands:
        dbcommands.c (r1.225 -> r1.225.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c?r1=1.225&r2=1.225.2.1)
        user.c (r1.187 -> r1.187.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c?r1=1.187&r2=1.187.2.1)
    pgsql/src/backend/utils/misc:
        guc.c (r1.505.2.5 -> r1.505.2.6)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.505.2.5&r2=1.505.2.6)
    pgsql/src/include/utils:
        guc.h (r1.102.2.2 -> r1.102.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h?r1=1.102.2.2&r2=1.102.2.3)

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2010-03-25 14:45:06
Subject: pgsql: Prevent ALTER USER f RESET ALL from removing the settings that
Previous:From: Alvaro HerreraDate: 2010-03-25 14:44:34
Subject: pgsql: Prevent ALTER USER f RESET ALL from removing the settings that

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group