Create a RULE wrapper around pg_user for the password entry

scrappy · scrappy · commit 04e3fd770dac · 1998-02-23T20:32:40.000Z
diff --git 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.35 1998/02/23 19:26:32 scrappy Exp $
+#    $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.36 1998/02/23 20:32:40 scrappy Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -358,7 +358,11 @@ echo "COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'" |\
 echo "GRANT SELECT ON pg_class TO PUBLIC" |\
 	 postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
 
-echo "create view db_user as select usename,usesysid from pg_user;" |\
+echo "CREATE RULE pg_user_hide_pw as on SELECT to pg_user.passwd DO INSTEAD SELECT '********' as passwd;" | \
+	postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
+	grep -v "'DEBUG:"
+
+echo "create view db_user as select * from pg_user;" |\
 	postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null |\
 	grep -v "'DEBUG:"
 echo "grant select on db_user to public" |\

Original file line number	Diff line number	Diff line change
`@@ -26,7 +26,7 @@`
`26`	`26`	`#`
`27`	`27`	`#`
`28`	`28`	`# IDENTIFICATION`
`29`		`-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.35 1998/02/23 19:26:32 scrappy Exp $`
	`29`	`+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.36 1998/02/23 20:32:40 scrappy Exp $`
`30`	`30`	`#`
`31`	`31`	`#-------------------------------------------------------------------------`
`32`	`32`
`@@ -358,7 +358,11 @@ echo "COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'" \|\`
`358`	`358`	`echo "GRANT SELECT ON pg_class TO PUBLIC" \|\`
`359`	`359`	`postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null \|\`
`360`	`360`
`361`		`-echo "create view db_user as select usename,usesysid from pg_user;" \|\`
	`361`	`+echo "CREATE RULE pg_user_hide_pw as on SELECT to pg_user.passwd DO INSTEAD SELECT '********' as passwd;" \| \`
	`362`	`+ postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null \|\`
	`363`	`+ grep -v "'DEBUG:"`
	`364`	`+`
	`365`	`+echo "create view db_user as select * from pg_user;" \|\`
`362`	`366`	`postgres -F -Q -D$PGDATA template1 2>&1 > /dev/null \|\`
`363`	`367`	`grep -v "'DEBUG:"`
`364`	`368`	`echo "grant select on db_user to public" \|\`