Rafael Domiciano написа:
> Hi folks,
> I'm new in this mailing list.
> I need to create a role (Postgres user) that cannot drop or create table,
> but can create TEMP tables. This role must do I, U and D normally.
> I have read some docs over the web and discovered that option to revoke
> "create table" doesn't exist.
> Can someone give me a light?!
For a role to be able to create tables (and other objects) it should
have "CREATE" privilege on the _schema_ in question. As for creating
temporary tables - "TEMP" ("TEMPORARY") privilege on the _database_ in
http://www.postgresql.org/docs/current/static/sql-grant.html for details.
Milen A. Radev
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-06-13 15:11:42|
|Subject: Re: Revoke for a new role |
|Previous:||From: Rafael Domiciano||Date: 2008-06-13 13:35:06|
|Subject: Revoke for a new role|