ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'CHAR';
CREATE USER pcr360_prod IDENTIFIED BY password1;
CREATE USER pcr360_prod_metadata IDENTIFIED BY password2;
GRANT CREATE TABLE TO pcr360_prod;
GRANT CREATE SEQUENCE TO pcr360_prod;
GRANT CREATE ANY INDEX TO pcr360_prod;
GRANT CREATE PROCEDURE TO pcr360_prod;
GRANT CREATE VIEW TO pcr360_prod;
GRANT CREATE SESSION TO pcr360_prod;
GRANT ALTER ANY TABLE TO pcr360_prod;
GRANT ALTER SESSION TO pcr360_prod;
GRANT LOCK ANY TABLE TO pcr360_prod;
GRANT DROP ANY SEQUENCE TO pcr360_prod;
GRANT SELECT ON V_$SESSION TO pcr360_prod;
GRANT UNLIMITED TABLESPACE TO pcr360_prod;
GRANT CREATE TABLE TO pcr360_prod_metadata;
GRANT CREATE SEQUENCE TO pcr360_prod_metadata;
GRANT CREATE ANY INDEX TO pcr360_prod_metadata;
GRANT CREATE PROCEDURE TO pcr360_prod_metadata;
GRANT CREATE VIEW TO pcr360_prod_metadata;
GRANT CREATE SESSION TO pcr360_prod_metadata;
GRANT ALTER ANY TABLE TO pcr360_prod_metadata;
GRANT ALTER SESSION TO pcr360_prod_metadata;
GRANT LOCK ANY TABLE TO pcr360_prod_metadata;
GRANT DROP ANY SEQUENCE TO pcr360_prod_metadata;
GRANT SELECT ON V_$SESSION TO pcr360_prod_metadata;
GRANT UNLIMITED TABLESPACE TO pcr360_prod_metadata;
GRANT CREATE TABLE TO pcr360_prod_archive;
GRANT CREATE SEQUENCE TO pcr360_prod_archive;
GRANT CREATE ANY INDEX TO pcr360_prod_archive;
GRANT CREATE PROCEDURE TO pcr360_prod_archive;
GRANT CREATE VIEW TO pcr360_prod_archive;
GRANT CREATE SESSION TO pcr360_prod_archive;
GRANT ALTER ANY TABLE TO pcr360_prod_archive;
GRANT ALTER SESSION TO pcr360_prod_archive;
GRANT LOCK ANY TABLE TO pcr360_prod_archive;
GRANT DROP ANY SEQUENCE TO pcr360_prod_archive;
GRANT SELECT ON V_$SESSION TO pcr360_prod_archive;
GRANT UNLIMITED TABLESPACE TO pcr360_prod_archive; | 