Query to create Domain User in Oracle

 

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;