Carol Walter <walterc(at)indiana(dot)edu> writes:
> How do you make a user that can only create temporary tables?
Well, you grant them TEMP privilege on the database, and you revoke
everything else. I suspect the key bit you're missing is to revoke
public CREATE privilege on the "public" schema.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Chris Bovitz||Date: 2008-07-29 21:03:54|
|Subject: Upgrading with WALs|
|Previous:||From: Carol Walter||Date: 2008-07-29 15:47:37|
|Subject: Privileges & roles|