Hi,
Give the follwoing command to revoke or give 0 quota on users tablespace .

alter user scott
quota 0 on users;

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]