> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026