Re: BUG #1497: Default permissions allow any user to create objects in any database

"Barry Brown" <barry@cs.sierracollege.edu> writes:
> I should not be able to do this.

Not everyone would agree with you.  But if you want to work that way,
revoke public CREATE privileges on the public schema, and revoke public
CREATE privileges on the database so people can't create new schemas.

            regards, tom lane