So, there is no manner to define that the user can't do create or drop objects, but can create temp tables? I have to do it manually?
I have been reading about a patch that increment the CREATE ROLE clausule, called "PATCH NOCREATETABLE"... This patch is what I need... someone had already hear some about? 2008/6/13 Tom Lane <[EMAIL PROTECTED]>: > "Milen A. Radev" <[EMAIL PROTECTED]> writes: > > Rafael Domiciano написа: > >> 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. > > > For a role to be able to create tables (and other objects) it should > > have "CREATE" privilege on the _schema_ in question. > > More specifically, what you're going to need to do is revoke "public" > create access on the public schema, and then selectively grant it to > everyone you want to have it. There's no notion of "everyone but X > gets this privilege". > > regards, tom lane >
