Commit44763a2

committed

Make usecatupd disabled for normal users, and allow normal users to

update temp tables with this setting.

1 parent04578a9 commit44763a2Copy full SHA for 44763a2

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`*`
`8`	`8`	`*`
`9`	`9`	`* IDENTIFICATION`
`10`		`- * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.26 1999/07/17 20:16:47 momjian Exp $`
	`10`	`+ * $Header: /cvsroot/pgsql/src/backend/catalog/aclchk.c,v 1.27 1999/07/30 18:09:44 momjian Exp $`
`11`	`11`	`*`
`12`	`12`	`* NOTES`
`13`	`13`	`* See acl.h.`
`@@ -392,6 +392,7 @@ pg_aclcheck(char relname, char usename, AclMode mode)`
`392`	`392`	`*/`
`393`	`393`	`if (((mode&ACL_WR)\|\| (mode&ACL_AP))&&`
`394`	`394`	`!allowSystemTableMods&&IsSystemRelationName(relname)&&`
	`395`	`+strncmp(relname,"pg_temp.",strlen("pg_temp."))!=0&&`
`395`	`396`	`!((Form_pg_shadow)GETSTRUCT(tuple))->usecatupd)`
`396`	`397`	`{`
`397`	`398`	`elog(DEBUG,"pg_aclcheck: catalog update to \"%s\": permission denied",`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`*`
`6`	`6`	`* Copyright (c) 1994, Regents of the University of California`
`7`	`7`	`*`
`8`		`- * $Id: user.c,v 1.32 1999/07/17 20:16:54 momjian Exp $`
	`8`	`+ * $Id: user.c,v 1.33 1999/07/30 18:09:47 momjian Exp $`
`9`	`9`	`*`
`10`	`10`	`*-------------------------------------------------------------------------`
`11`	`11`	`*/`
`@@ -169,7 +169,7 @@ DefineUser(CreateUserStmt *stmt, CommandDest dest)`
`169`	`169`	`snprintf(sql,SQL_LENGTH,`
`170`	`170`	`"insert into %s (usename,usesysid,usecreatedb,usetrace,"`
`171`	`171`	`"usesuper,usecatupd,passwd,valuntil) "`
`172`		`-"values('%s',%d,'%c','t','%c','t',%s%s%s,%s%s%s)",`
	`172`	`+"values('%s',%d,'%c','f','%c','f',%s%s%s,%s%s%s)",`
`173`	`173`	`ShadowRelationName,`
`174`	`174`	`stmt->user,`
`175`	`175`	`max_id+1,`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@`
`8`	`8`	`#`
`9`	`9`	`#`
`10`	`10`	`# IDENTIFICATION`
`11`		`-# $Header: /cvsroot/pgsql/src/bin/createuser/Attic/createuser.sh,v 1.11 1999/01/31 05:04:25 scrappy Exp $`
	`11`	`+# $Header: /cvsroot/pgsql/src/bin/createuser/Attic/createuser.sh,v 1.12 1999/07/30 18:09:49 momjian Exp $`
`12`	`12`	`#`
`13`	`13`	`# Note - this should NOT be setuid.`
`14`	`14`	`#`
`@@ -218,7 +218,7 @@ fi`
`218`	`218`	`QUERY="insert into pg_shadow\`
`219`	`219`	`(usename, usesysid, usecreatedb, usetrace, usesuper, usecatupd)\`
`220`	`220`	`values\`
`221`		`- ('$NEWUSER',$SYSID, '$CANCREATE', 't', '$CANADDUSER','t')"`
	`221`	`+ ('$NEWUSER',$SYSID, '$CANCREATE', 'f', '$CANADDUSER','f')"`
`222`	`222`
`223`	`223`	RES=`$PSQL -c"$QUERY" template1`
`224`	`224`

Comments

(0)