"Andy Shellam" <andy(dot)shellam(at)mailnetwork(dot)co(dot)uk> writes:
> I believe you could probably do this best with table spaces.
Right, that's the thing to use.
> There is a downside in that the user could create a new table and override
> the table space to that of another user.
Not with appropriate permissions set on the tablespaces.
regards, tom lane