On Mon, 17 May 2004, Gregory S. Williamson wrote:
> Stephan,
>
> Thanks for the info, but alas, no success.
>
> I have:
> List of database users
> User name | User ID | Attributes
> -----------+---------+----------------------------
> testuser | 100 |
> postgres | 1 | superuser, create database
>
>
> And as postgres I ran:
> REVOKE ALL ON SCHEMA public FROM testuser;
I forgot to mention something which led to the confusion.
testuser doesn't probably have permissions on the public schema, but
public (all users) does. You probably need to revoke it from PUBLIC
and grant it to the users who should have creation rights to public.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
