From f9b4db1a48ccd2d7e5012fb193562773d685d4b4 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 14 Jan 2004 03:47:12 +0000 Subject: [PATCH] pg_settings should have UPDATE privilege allowed to public. (Can't force initdb for this in 7.4 branch, but we can at least see to it that post-7.4.2 installations will get it right.) --- src/bin/initdb/initdb.sh | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh index 21a77d8d5a..a04d605659 100644 --- a/src/bin/initdb/initdb.sh +++ b/src/bin/initdb/initdb.sh @@ -1027,6 +1027,8 @@ CREATE RULE pg_settings_n AS \ ON UPDATE TO pg_settings \ DO INSTEAD NOTHING; +GRANT SELECT, UPDATE ON pg_settings TO PUBLIC; + EOF if [ "$?" -ne 0 ]; then exit_nicely -- 2.39.5