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
