"Andy Shellam" <andy.shellam@mailnetwork.co.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