Re: Deny creation of tables for a user

[Pascal Cohen <pcohen(at)wimba(dot)com>]

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