Commit2df6bba

committed

From: PostgreSQL DataBase <postgres@scuba.pcpipeline.com>

This again fixes the problemwith the default permissions for PUBLIC and the preventing ofstatements like "GRANT null on test to test_user;".

1 parentb7ed95a commit2df6bbaCopy full SHA for 2df6bba

File tree

+20

-5

lines changed

+20

-5

lines changed

Lines changed: 20 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -21,7 +21,7 @@`
`21`	`21`	`*`
`22`	`22`	`*`
`23`	`23`	`* IDENTIFICATION`
`24`		`- * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.61 1998/01/29 02:26:25 scrappy Exp $`
	`24`	`+ * $Header: /cvsroot/pgsql/src/bin/pg_dump/pg_dump.c,v 1.62 1998/01/30 15:03:35 scrappy Exp $`
`25`	`25`	`*`
`26`	`26`	`* Modifications - 6/10/96 - dave@bensoft.com - version 1.13.dhb`
`27`	`27`	`*`
`@@ -2481,11 +2481,26 @@ dumpTables(FILE fout, TableInfo tblinfo, int numTables,`
`2481`	`2481`
`2482`	`2482`	`if (acls) {`
`2483`	`2483`	`ACLlist=ParseACL(tblinfo[i].relacl,&l);`
	`2484`	`+if (ACLlist== (ACL*)NULL)`
	`2485`	`+if (l==0)`
	`2486`	`+continue;`
	`2487`	`+else {`
	`2488`	`+fprintf(stderr,"Could not parse ACL list for %s...Exiting!\n",`
	`2489`	`+tblinfo[i].relname);`
	`2490`	`+exit_nicely(g_conn);`
	`2491`	`+}`
	`2492`	`+`
	`2493`	`+/* Revoke Default permissions for PUBLIC */`
	`2494`	`+fprintf(fout,`
	`2495`	`+"REVOKE ALL on %s from PUBLIC;\n",`
	`2496`	`+tblinfo[i].relname);`
	`2497`	`+`
`2484`	`2498`	`for(k=0;k<l;k++) {`
`2485`		`-fprintf(fout,`
`2486`		`-"GRANT %s on %s to %s;\n",`
`2487`		`-ACLlist[k].privledges,tblinfo[i].relname,`
`2488`		`-ACLlist[k].user);`
	`2499`	`+if (ACLlist[k].privledges!= (char*)NULL)`
	`2500`	`+fprintf(fout,`
	`2501`	`+"GRANT %s on %s to %s;\n",`
	`2502`	`+ACLlist[k].privledges,tblinfo[i].relname,`
	`2503`	`+ACLlist[k].user);`
`2489`	`2504`	`}`
`2490`	`2505`	`}`
`2491`	`2506`	`}`

Comments

(0)