Create Oracle schema (user)

create_schema.sql

-- drop / create user 
drop user xdev01 CASCADE;

CREATE USER xdev01 IDENTIFIED BY xdev01;  

ALTER USER xdev01 
DEFAULT TABLESPACE USERS 
TEMPORARY TABLESPACE TEMP 
ACCOUNT UNLOCK;  

GRANT "CONNECT" TO xdev01;
GRANT "RESOURCE" TO xdev01;


-- drop / create user 
drop user xdev02 CASCADE;

CREATE USER xdev02 IDENTIFIED BY xdev02;  

ALTER USER xdev02 
DEFAULT TABLESPACE USERS 
TEMPORARY TABLESPACE TEMP 
ACCOUNT UNLOCK;  

GRANT "CONNECT" TO xdev02;
GRANT "RESOURCE" TO xdev02;

-- drop / create user 
drop user xdev03 CASCADE;

CREATE USER xdev03 IDENTIFIED BY xdev03;  

ALTER USER xdev03 
DEFAULT TABLESPACE USERS 
TEMPORARY TABLESPACE TEMP 
ACCOUNT UNLOCK;  

GRANT "CONNECT" TO xdev03;
GRANT "RESOURCE" TO xdev03;