On Tue, 04 Dec 2007 20:39:10 -0000, Dave Hughes <dave@waveform.plus.com>
wrote:

[snip]
> Simply ensure that tablespace "ABC" is the only one the user holds the
> "USE" privilege on (which is necessary to create tables). In other
> words, "REVOKE USE OF TABLESPACE USERSPACE1 FROM USER username" and
> similarly for any other tablespaces the user holds the USE privilege on.

Oops - quick correction to the above that's just occurred to me:

....for any other *regular* tablespaces the user holds the USE privilege
on. Leave the temporary tablespace privileges alone...


Cheers,

Dave.