DROP TABLESPACE domain_dev_ts INCLUDING CONTENTS;
CREATE TABLESPACE domain_dev_ts DATAFILE SIZE 50 M AUTOEXTEND ON NEXT 10 M MAXSIZE UNLIMITED FORCE LOGGING ONLINE FLASHBACK OFF;
DROP USER domain_dev CASCADE;
CREATE USER domain_dev IDENTIFIED BY DB105you DEFAULT TABLESPACE domain_dev_ts TEMPORARY TABLESPACE temp QUOTA 0 ON USERS QUOTA 0 ON SYSTEM QUOTA 0 ON SYSAUX QUOTA UNLIMITED ON domain_dev_ts;
GRANT CONNECT, RESOURCE TO domain_dev;
GRANT CREATE TABLE TO domain_dev;
GRANT CREATE VIEW TO domain_dev;
GRANT CREATE SEQUENCE TO domain_dev;
GRANT CREATE SESSION TO domain_dev;
GRANT CREATE SYNONYM TO domain_dev;