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.
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I don't have a better idea, but I am wondering how this will work. If I
> > create a schema with my name, does it get added to the front of my
> > schema schema search path automatically,
>
> Yes (unless you've futzed with the stand
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I don't have a better idea, but I am wondering how this will work. If I
> create a schema with my name, does it get added to the front of my
> schema schema search path automatically,
Yes (unless you've futzed with the standard value of search_path).
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I am a little uncomfortable about this. It means that CREATE TABLE will
> > create a table in 'public' if the user doesn't have a schema of their
> > own, and in their private schema if it exists. I seems strange to have
> > such a
