Re: Keep a user from creating tables ?

Of course ... implicit in the docs if I reread them.

Thanks very much for the tip ...
G
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone.bigpanda.com]
Sent: Monday, May 17, 2004 1:45 PM
To: Gregory S. Williamson
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Keep a user from creating tables ?



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.