CREATE USER username IDENTIFIED BY password

DEFAULT TABLESPACE tablespacename

TEMPORARY TABLESPACE "temptablespacename";