Re: user manage their own pg_hba entries - Mailing list pgsql-novice

I guess this is why its the novice forum -
thanks tom
On Sun, 2006-07-30 at 12:02 -0400, Tom Lane wrote:
> Glenn Davy <glenn@tangelosoftware.net> writes:
> > i've allowed all 'host' users to connect from 127.0.0.1/32 to all
> > databases, then used grant/revoke to limit what they can do - except I
> > cant seem to see how I can limit user A from creating tables in database
> > owned by user B?
>
> It's not a database-level privilege, it's a schema-level privilege.
> Revoke CREATE on the public schema.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org