Create Users in Repository Database

The following statements show an example of creating users in the Repository Database:

CREATE TABLESPACE INFA_REP_USER_TS_adw DATAFILE '/u01/app/Oracle/oradata/orcl/orclpdb/INFA_REP_USER_TS_adw.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TEMPORARY TABLESPACE INFA_REP_USER_TMP_TS_adw TEMPFILE '/u01/app/Oracle/oradata/orcl/orclpdb/INFA_REP_USER_TMP_TS_adw.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

CREATE USER INFA_WIL_REP_DB_USER_adw IDENTIFIED BY Welcome_1111 DEFAULT TABLESPACE INFA_REP_USER_TS_adw TEMPORARY TABLESPACE INFA_REP_USER_TMP_TS_adw QUOTA UNLIMITED ON INFA_REP_USER_TS_adw ;
GRANT CONNECT, RESOURCE, create any directory,CREATE VIEW  TO INFA_WIL_REP_DB_USER_adw;

CREATE USER INFA_HCD_REP_DB_USER_adw IDENTIFIED BY Welcome_1111 DEFAULT TABLESPACE INFA_REP_USER_TS_adw TEMPORARY TABLESPACE INFA_REP_USER_TMP_TS_adw QUOTA UNLIMITED ON INFA_REP_USER_TS_adw ;
GRANT CONNECT, RESOURCE, create any directory,CREATE VIEW  TO INFA_HCD_REP_DB_USER_adw;
--GRANT ALTER SESSION,CREATE DIRECTORY,CREATE INDEXTYPE,CREATE JOB,CREATE MATERIALIZED VIEW,CREATE PROCEDURE,CREATE SEQUENCE,CREATE SESSION,CREATE SYNONYM,CREATE TABLE,CREATE TRIGGER,CREATE TYPE,CREATE VIEW TO INFA_HCD_REP_DB_USER_adw;

CREATE USER INFA_CDM_REP_DB_USER_adw IDENTIFIED BY Welcome_1111 DEFAULT TABLESPACE INFA_REP_USER_TS_adw TEMPORARY TABLESPACE INFA_REP_USER_TMP_TS_adw QUOTA UNLIMITED ON INFA_REP_USER_TS_adw ;
GRANT CONNECT, RESOURCE, create any directory,CREATE VIEW  TO INFA_CDM_REP_DB_USER_adw;