create USER QDAS IDENTIFIED BY QDAS; grant connect to QDAS; grant resource to QDAS; alter user QDAS default tablespace qdas_default; alter user QDAS temporary tablespace temp; -- if a separate index tablespace is required, un-comment the following line: -- alter user QDAS default tablespace qdas_def_ix;