Re: [HACKERS] Cannot insert into temp tables

> Bruce Momjian wrote:
> ...
> >OK, you have good points. usecatupd should not be set by default.
> >Making changes to the system tables can mess things up for everyone.
> >Initdb will give the postgres superuser permissions, but now createuser
> >and the SQL command CREATE USER will not give this permission. Also, I
> >have fixed the code so temp tables, which are acutally named pg_temp,
> >can be updated by normal users without usecatupd permissions.
> >
> >Attached is a patch. I will apply it to the current tree.
>
> Bruce, this change has some other implications. I tested
> the effect of the patch by altering the rights of my own account (setting
> usecatupd to false). I cannot now create other users: although usesuper is
> true, the attempt to update pg_shadow with the new user's row fails:

OK, I have committed a fix for this. I now give update catalog rights
to anyone who has createdb or super-user rights. This is in the current
tree only. Let me know if you see any additional problems.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026