-- create table space. CREATE TABLESPACE datafile '/.dbf' size M autoextend on maxsize m; -- create schema. CREATE USER EUL_US IDENTIFIED BY DEFAULT TABLESPACE TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- execute required grants . GRANT RESOURCE TO ; GRANT CONNECT TO ; GRANT ANALYZE ANY TO ; GRANT CREATE ROLE TO ; GRANT CREATE VIEW TO ; GRANT CREATE TABLE TO ; GRANT CREATE SESSION TO ; GRANT CREATE SEQUENCE TO ; GRANT CREATE PROCEDURE TO ; GRANT SELECT ANY TABLE TO ; GRANT ALTER ANY SNAPSHOT TO ; GRANT CREATE ANY SNAPSHOT TO ; GRANT GLOBAL QUERY REWRITE TO ; GRANT SELECT ANY TABLE TO ; GRANT EXECUTE ANY PROCEDURE TO ; GRANT ALTER ANY MATERIALIZED VIEW TO ; GRANT CREATE ANY MATERIALIZED VIEW TO ; GRANT DROP ANY MATERIALIZED VIEW TO ; GRANT GL10_LEDGER TO ; GRANT GL15_LEDGER TO ; GRANT APCA_PAYABLES TO ; GRANT APCFA_PAYABLES TO ; GRANT FA_FIXED_ASSETS TO ; GRANT INALL_INVENTORY TO ; GRANT INCAE_INVENTORY TO ; GRANT INCFE_INVENTORY TO ; GRANT INCIM_INVENTORY TO ; GRANT POCA_PURCHASING TO ; GRANT ARCA_RECEIVABLES TO ; GRANT OECA_ORDER_ENTRY TO ; GRANT POCFA_PURCHASING TO ; GRANT XXNAO_NOETIX_ADMIN TO ; GRANT SELECT ON DBA_JOBS_RUNNING TO ; -- allocate unlimited quota on tablespace ALTER USER QUOTA UNLIMITED ON ; Example: CREATE TABLESPACE disco10g datafile '/i01/itest3/oracle/itest3data/disco10g_1.dbf' size 1500M autoextend on maxsize 2048m; CREATE USER EUL5_US IDENTIFIED BY disco DEFAULT TABLESPACE DISCO10g TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT RESOURCE TO EUL5_US; GRANT CONNECT TO EUL5_US; GRANT ANALYZE ANY TO EUL5_US; GRANT CREATE ROLE TO EUL5_US; GRANT CREATE VIEW TO EUL5_US; GRANT CREATE TABLE TO EUL5_US; GRANT CREATE SESSION TO EUL5_US; GRANT CREATE SEQUENCE TO EUL5_US; GRANT CREATE PROCEDURE TO EUL5_US; GRANT SELECT ANY TABLE TO EUL5_US; GRANT ALTER ANY SNAPSHOT TO EUL5_US; GRANT CREATE ANY SNAPSHOT TO EUL5_US; GRANT GLOBAL QUERY REWRITE TO EUL5_US; GRANT SELECT ANY TABLE TO EUL5_US ; GRANT EXECUTE ANY PROCEDURE TO EUL5_US; GRANT GL10_LEDGER TO EUL5_US ; GRANT GL15_LEDGER TO EUL5_US ; GRANT APCA_PAYABLES TO EUL5_US ; GRANT APCFA_PAYABLES TO EUL5_US ; GRANT FA_FIXED_ASSETS TO EUL5_US ; GRANT INALL_INVENTORY TO EUL5_US ; GRANT INCAE_INVENTORY TO EUL5_US ; GRANT INCFE_INVENTORY TO EUL5_US ; GRANT INCIM_INVENTORY TO EUL5_US ; GRANT POCA_PURCHASING TO EUL5_US ; GRANT ARCA_RECEIVABLES TO EUL5_US ; GRANT OECA_ORDER_ENTRY TO EUL5_US ; GRANT POCFA_PURCHASING TO EUL5_US ; GRANT XXNAO_NOETIX_ADMIN TO EUL5_US ; GRANT SELECT ON DBA_JOBS_RUNNING TO EUL5_US; GRANT ALTER ANY MATERIALIZED VIEW TO EUL5_US; GRANT CREATE ANY MATERIALIZED VIEW TO EUL5_US; GRANT DROP ANY MATERIALIZED VIEW TO EUL5_US; ALTER USER EUL5_US QUOTA UNLIMITED ON DISCO10G;