Bruce Momjian <pgman@candle.pha.pa.us> 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