Originally posted by msuresh
Dont be smart.I asked you how to restrict other users if they were not using default tablespace in their script.
I think you should be more smart, or at least read some documents to understand basics before attacing others that are trying to help you.
Originally posted by msuresh
create user xyz identified by xyz
default tablespace TBS_NAME
temporary tablespace TEMP ;
There's absolutely nothing smart in that, it's just how users should be created. And if you had been smart enough you would have realised that the above command creates a user that can't create any object in any tablespace whatsoever - not in TBS_NAME (the default tablespace for that user), nor in any other tablespace!

It's not the assigned defaut tablespace that gives user the ability to create objects - it's what privileges and tablespace quotas you assign to that user.