


CREATE USER SPLADM IDENTIFIED BY SPLADM
DEFAULT TABLESPACE CISTS_01
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT;


CREATE ROLE SPL_USER;
CREATE ROLE SPL_READ;

GRANT UNLIMITED TABLESPACE TO SPLADM;
GRANT CONNECT TO SPLADM;
GRANT CREATE SESSION TO SPLADM;
GRANT CREATE ANY TABLE TO SPLADM;
GRANT CREATE ANY INDEX TO SPLADM;
GRANT CREATE ANY VIEW TO SPLADM;
GRANT CREATE ANY MATERIALIZED VIEW TO SPLADM;
GRANT CREATE ANY INDEX TO SPLADM;
GRANT CREATE ANY SYNONYM TO SPLADM;
GRANT CREATE ANY TRIGGER TO SPLADM;
GRANT CREATE ANY SEQUENCE TO SPLADM;
GRANT SELECT ON V_$SESSION TO SPLADM;

CREATE USER SPLUSER PROFILE DEFAULT IDENTIFIED BY SPLUSER
DEFAULT TABLESPACE CISTS_01
TEMPORARY TABLESPACE TEMP;

GRANT SELECT ANY TABLE TO SPLUSER;
GRANT SPL_USER TO SPLUSER;
GRANT CONNECT TO SPLUSER;

CREATE USER SPLREAD IDENTIFIED BY SPLREAD
DEFAULT TABLESPACE CISTS_01
TEMPORARY TABLESPACE TEMP;

GRANT SELECT ANY TABLE TO SPLREAD;
GRANT SPL_READ TO SPLREAD;
GRANT CONNECT TO SPLREAD;
