Creating user

To create a user:

create user username identified by password default tablespace TSName temporary tablespace TEMPTSName quota 10M on TSName ;

or

create user username identified by password default tablespace TSName temporary tablespace TEMPTSName quota unlimited on TSName ;

If you forgot to add the quota for users on tablespace then:

alter user quota quota unlimited on TSName ;