Re: Deny creation of tables for a user

Terry Lee Tucker wrote:
> On Wednesday 23 April 2008 06:46, Pascal Cohen wrote:
>
>> Hello
>> I am playing with security in Postgres
>> And I would like to have a database that can be managed by a given user
>> that could do almost anything but I would also have a user that can just
>> handle what is created.
>> I mean she could insert, update delete rows but not create tables.
>>
>> I did not find a way to revoke such thing. Is it possible ?
>>
>> Thanks!
>>
>
> Have you looked at GRANT?
> http://www.postgresql.org/docs/8.3/interactive/sql-grant.html
>
>
Yes I did.
In fact I looked at GRANT and REVOKE commands but I would like to define
that a role r cannot create a new table and I did not find the way to do so.
I can prevent him from inserting or updating in an existing table but
not to create a new table