Run the following script to create a role, a user and a tablespace for CloverETL server.

Role: cloverRole

User: cloverUser

Password: cloverPassword

-- Create a new  role and grant it privileges
CREATE ROLE cloverRole NOT IDENTIFIED;

GRANT CREATE SESSION TO cloverRole;
GRANT ALTER SESSION TO cloverRole;
GRANT CREATE TABLE TO cloverRole;
GRANT CREATE SEQUENCE TO cloverRole;
GRANT CREATE TRIGGER TO cloverRole;

-- Create a new database user with password
CREATE USER cloverUser IDENTIFIED BY cloverPassword;

-- Set quota on tablespace
GRANT UNLIMITED TABLESPACE TO cloverUser;

-- Connect a new role to a new user
GRANT cloverRole TO cloverUser;

If you use a properties file for configuration, specify these parameters: jdbc.driverClassName, jdbc.url, jdbc.username, jdbc.password, jdbc.dialect. For example:

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@host:1521:db
jdbc.username=user
jdbc.password=pass
jdbc.dialect=org.hibernate.dialect.Oracle10gDialect
		

Please don't forget to add a JDBC 4 compliant driver on the classpath. A JDBC driver which doesn't meet the JDBC 4 specifications won't work properly.

These are privileges which have to be granted to schema used by CloverETL Server:

CONNECT
CREATE SESSION
CREATE/ALTER/DROP TABLE
CREATE/ALTER/DROP SEQUENCE

QUOTA UNLIMITED ON <user_tablespace>;
QUOTA UNLIMITED ON <temp_tablespace>;

	Note
	Continue with:  Encrypted JNDI or CloverETL Server Activation