DEFINE _us  = intershop
DEFINE _pwd = intershop

CREATE USER &_us
IDENTIFIED BY &_pwd
DEFAULT TABLESPACE is_users
TEMPORARY TABLESPACE is_temp
PROFILE DEFAULT ACCOUNT UNLOCK;

ALTER USER &_us DEFAULT ROLE ALL;

GRANT CONNECT TO &_us;
GRANT RESOURCE TO &_us;
GRANT CTXAPP TO &_us;

ALTER USER &_us QUOTA UNLIMITED ON is_users;
ALTER USER &_us QUOTA UNLIMITED ON is_indx;
ALTER USER &_us QUOTA UNLIMITED ON is_indx_ctx;

GRANT CREATE CLUSTER TO &_us;
GRANT CREATE DATABASE LINK TO &_us;
GRANT CREATE SEQUENCE TO &_us;
GRANT CREATE SYNONYM TO &_us;
GRANT CREATE TABLE TO &_us;
GRANT CREATE VIEW TO &_us;
GRANT CREATE PROCEDURE TO &_us;
GRANT CREATE TRIGGER TO &_us;
GRANT CREATE TYPE TO &_us;
GRANT CREATE SNAPSHOT TO &_us;

GRANT ANALYZE ANY TO &_us;

GRANT EXECUTE ON DBMS_STREAMS_ADM TO &_us;
GRANT EXECUTE ON CTX_DDL TO &_us;