|
26 | 26 | # |
27 | 27 | # |
28 | 28 | # IDENTIFICATION |
29 | | -# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.35 1998/02/2319:26:32 scrappy Exp $ |
| 29 | +# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.36 1998/02/2320: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 template12>&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 template12>&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 template12>&1> /dev/null|\ |
363 | 367 | grep -v"'DEBUG:" |
364 | 368 | echo"grant select on db_user to public"|\ |
|