If it is a single user (ie database account) that you want to restrict why not just create a TEMPORARY Tablespace assigned to that user alone and limit the sizes of the TEMPFILES for that Tablespace ?
We have certain Users running queries that frequently fill-up the TEMP tablespace. Is there a way to specify quota on TEMP. We are on 10gR2 and I already found that this stopped working in 10gR2 (it was in fact a Bug in earlier versions).
Hemant K Chitale http://web.singnet.com.sg/~hkchital