create USER QDAS IDENTIFIED BY QDAS; grant connect to QDAS; grant resource to QDAS; grant create view to QDAS; GRANT CREATE SYNONYM TO QDAS; alter user QDAS default tablespace qdas_default; alter user QDAS temporary tablespace temp; alter user QDAS QUOTA UNLIMITED ON qdas_default; alter user QDAS QUOTA UNLIMITED ON qwert_table; alter user QDAS QUOTA UNLIMITED ON qmerk_table; alter user QDAS QUOTA UNLIMITED ON qwert_index; alter user QDAS QUOTA UNLIMITED ON qmerk_index; -- if a separate index tablespace is required, un-comment the following lines: -- alter user QDAS default tablespace qdas_def_ix; -- alter user QDAS QUOTA UNLIMITED ON qdas_def_ix;