aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2004-01-14 03:47:12 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2004-01-14 03:47:12 +0000
commit91d4f280dda9a8bf1b8aed655e068e66a5588e7c (patch)
treeb664e8ef3cb26e7bfa4f31d6963891073763513b /src
parentf07c69ae57eb3b581547701dd32dc7e7f82aecd3 (diff)
downloadpostgresql-91d4f280dda9a8bf1b8aed655e068e66a5588e7c.tar.gz
postgresql-91d4f280dda9a8bf1b8aed655e068e66a5588e7c.zip
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.)
Diffstat (limited to 'src')
-rw-r--r--src/bin/initdb/initdb.sh4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh
index ed396c4bc28..9099d07c3f7 100644
--- a/src/bin/initdb/initdb.sh
+++ b/src/bin/initdb/initdb.sh
@@ -27,7 +27,7 @@
# Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
# Portions Copyright (c) 1994, Regents of the University of California
#
-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.204 2003/10/13 21:06:44 tgl Exp $
+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.204.2.1 2004/01/14 03:47:12 tgl Exp $
#
#-------------------------------------------------------------------------
@@ -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