Bruce Momjian <[EMAIL PROTECTED]> writes:
> If I remove public create access to public, can the super user or db
> owner still create tables?

Superusers can always do whatever they want.

The DB owner (assume he's not a superuser) has no special privileges
w.r.t. the public schema at the moment.  We could perhaps put in a
kluge to change this, but it would definitely be a kluge --- I don't
see any clean way to make the behavior different.

One possible approach would be for a superuser to change the ownership
of public to be the DB owner.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to