Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit86af627

Browse files
committed
From: Andreas.Zeugswetter@telecom.at
Improved fix to pg_user/passwd problem...using rewrite rules
1 parentdf67b83 commit86af627

File tree

1 file changed

+13
-1
lines changed

1 file changed

+13
-1
lines changed

‎src/bin/initdb/initdb.sh

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -26,7 +26,7 @@
2626
#
2727
#
2828
# IDENTIFICATION
29-
# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.32 1998/02/19 17:19:45 momjian Exp $
29+
# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.33 1998/02/19 17:25:58 scrappy Exp $
3030
#
3131
#-------------------------------------------------------------------------
3232

@@ -351,6 +351,18 @@ echo "vacuuming template1"
351351
echo"vacuum"| postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
352352
grep -v"^DEBUG:"
353353

354+
echo"Altering pg_user acl"
355+
echo"REVOKE ALL ON pg_user FROM public"| \
356+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
357+
grep -v"'DEBUG:"
358+
echo"GRANT SELECT ON pg_user TO public"| \
359+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
360+
grep -v"'DEBUG:"
361+
echo"CREATE RULE pg_user_hide_pw as on SELECT to pg_user.passwd DO INSTEAD SELE
362+
CT '********' as passwd;"| \
363+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
364+
grep -v"'DEBUG:"
365+
354366
echo"COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'"| postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
355367
grep -v"'DEBUG:"
356368

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp