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