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:46:06
Message-ID: 20100325144606.6C01C7541D1@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:
----
REL7_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/commands:
        dbcommands.c (r1.124.2.2 -> r1.124.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/dbcommands.c?r1=1.124.2.2&r2=1.124.2.3)
        user.c (r1.128 -> r1.128.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c?r1=1.128&r2=1.128.2.1)
    pgsql/src/backend/utils/misc:
        guc.c (r1.164.2.8 -> r1.164.2.9)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c?r1=1.164.2.8&r2=1.164.2.9)
    pgsql/src/include/utils:
        guc.h (r1.41 -> r1.41.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h?r1=1.41&r2=1.41.2.1)

pgsql-committers by date

Next:From: Tom LaneDate: 2010-03-25 15:50:10
Subject: pgsql: Fix ginint4_queryextract() to actually do what it was intended to
Previous:From: Alvaro HerreraDate: 2010-03-25 14:45:51
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