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

Commitab6e4ea

Browse files
committed
Modify initdb.sh so that it makes pg_user readable through view db_user
Modify psql so that it uses db_user instead of pg_userGRANT SELECT on pg_class
1 parent0b4620b commitab6e4ea

File tree

2 files changed

+20
-9
lines changed

2 files changed

+20
-9
lines changed

‎src/bin/initdb/initdb.sh

Lines changed: 14 additions & 3 deletions
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.34 1998/02/20 01:44:18 scrappy Exp $
29+
# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.35 1998/02/23 19:26:32 scrappy Exp $
3030
#
3131
#-------------------------------------------------------------------------
3232

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

354-
echo"COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'"| postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
355-
grep -v"'DEBUG:"
354+
echo"COPY pg_user TO '$PGDATA/pg_pwd' USING DELIMITERS '\\t'"|\
355+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
356+
grep -v"'DEBUG:"
357+
358+
echo"GRANT SELECT ON pg_class TO PUBLIC"|\
359+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
360+
361+
echo"create view db_user as select usename,usesysid from pg_user;"|\
362+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
363+
grep -v"'DEBUG:"
364+
echo"grant select on db_user to public"|\
365+
postgres -F -Q -D$PGDATA template12>&1> /dev/null|\
366+
grep -v"'DEBUG:"
356367

357368
echo"loading pg_description"
358369
echo"copy pg_description from '$TEMPLATE_DESCR'"| postgres -F -Q -D$PGDATA template1> /dev/null

‎src/bin/psql/psql.c

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
*
99
* IDENTIFICATION
10-
* $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.133 1998/02/07 06:11:47 momjian Exp $
10+
* $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.134 1998/02/23 19:26:36 scrappy Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -333,7 +333,7 @@ tableList(PsqlSettings *pset, bool deep_tablelist, char info_type,
333333

334334
listbuf[0]='\0';
335335
strcat(listbuf,"SELECT usename, relname, relkind, relhasrules ");
336-
strcat(listbuf,"FROM pg_class,pg_user ");
336+
strcat(listbuf,"FROM pg_class,db_user ");
337337
switch (info_type)
338338
{
339339
case't':
@@ -351,9 +351,9 @@ tableList(PsqlSettings *pset, bool deep_tablelist, char info_type,
351351
break;
352352
}
353353
if (!system_tables)
354-
strcat(listbuf," and relname !~ '^pg_'");
354+
strcat(listbuf," and relname !~ '^[dp][bg]_'");
355355
else
356-
strcat(listbuf," and relname ~ '^pg_'");
356+
strcat(listbuf," and relname ~ '^[dp][bg]_'");
357357
strcat(listbuf," and relname !~ '^xin[vx][0-9]+'");
358358

359359
/*
@@ -492,9 +492,9 @@ rightsList(PsqlSettings *pset)
492492

493493
listbuf[0]='\0';
494494
strcat(listbuf,"SELECT relname, relacl ");
495-
strcat(listbuf,"FROM pg_class,pg_user ");
495+
strcat(listbuf,"FROM pg_class,db_user ");
496496
strcat(listbuf,"WHERE ( relkind = 'r' OR relkind = 'i' OR relkind = 'S') ");
497-
strcat(listbuf," and relname !~ '^pg_'");
497+
strcat(listbuf," and relname !~ '^[dp][bg]_'");
498498
strcat(listbuf," and relname !~ '^xin[vx][0-9]+'");
499499
strcat(listbuf," and usesysid = relowner");
500500
strcat(listbuf," ORDER BY relname ");

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp