From 86af6275a722460e402d9025fc0fa9fca4170403 Mon Sep 17 00:00:00 2001 From: "Marc G. Fournier" Date: Thu, 19 Feb 1998 17:25:58 +0000 Subject: [PATCH] From: Andreas.Zeugswetter@telecom.at Improved fix to pg_user/passwd problem...using rewrite rules --- src/bin/initdb/initdb.sh | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh index 65e6458550..9a85dc6247 100644 --- a/src/bin/initdb/initdb.sh +++ b/src/bin/initdb/initdb.sh @@ -26,7 +26,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.32 1998/02/19 17:19:45 momjian Exp $ +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.33 1998/02/19 17:25:58 scrappy Exp $ # #------------------------------------------------------------------------- @@ -351,6 +351,18 @@ echo "vacuuming template1" echo "vacuum" | postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\ grep -v "^DEBUG:" +echo "Altering pg_user acl" +echo "REVOKE ALL ON pg_user FROM public" | \ + postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\ + grep -v "'DEBUG:" +echo "GRANT SELECT ON pg_user TO public" | \ + postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\ + grep -v "'DEBUG:" +echo "CREATE RULE pg_user_hide_pw as on SELECT to pg_user.passwd DO INSTEAD SELE +CT '********' as passwd;" | \ + postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\ + grep -v "'DEBUG:" + echo "COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'" | postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\ grep -v "'DEBUG:" -- 2.40.0