Re: Keep a user from creating tables ? - Mailing list pgsql-admin

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.