--  Create the test databases for Oracle in order to run
--  Unit tests for oracle.

-- Drop users:
DROP USER "JDBC2XML_DB1" CASCADE;
DROP USER "JDBC2XML_DB2" CASCADE;
DROP USER "JDBC2XML_DB3" CASCADE;
DROP USER "JDBC2XML_DB4" CASCADE;
DROP USER "JDBC2XML_DB5" CASCADE;
DROP USER "JDBC2XML_DB6" CASCADE;

--  Create users:
CREATE USER "JDBC2XML_DB1" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
CREATE USER "JDBC2XML_DB2" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
CREATE USER "JDBC2XML_DB3" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
CREATE USER "JDBC2XML_DB4" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
CREATE USER "JDBC2XML_DB5" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";
CREATE USER "JDBC2XML_DB6" IDENTIFIED BY "lmx2cbdj!" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP";

--  Grant:
GRANT CONNECT,RESOURCE to "JDBC2XML_DB1";
GRANT CONNECT,RESOURCE to "JDBC2XML_DB2";
GRANT CONNECT,RESOURCE to "JDBC2XML_DB3";
GRANT CONNECT,RESOURCE to "JDBC2XML_DB4";
GRANT CONNECT,RESOURCE to "JDBC2XML_DB5";
GRANT CONNECT,RESOURCE to "JDBC2XML_DB6";
