Re: Privileges & roles - Mailing list pgsql-admin

From Tom Lane
Subject Re: Privileges & roles
Date
Msg-id 14381.1217358518@sss.pgh.pa.us
Whole thread Raw
In response to Privileges & roles  (Carol Walter <walterc@indiana.edu>)
List pgsql-admin
Carol Walter <walterc@indiana.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

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Privileges & roles
Next
From: Chris Bovitz
Date:
Subject: Upgrading with WALs