Oracle

Creating database

CloverDX Server setup

Creating database

Run the following script to create a role (cloverRole), user (cloverUser) with password (cloverPassword) and tablespace for CloverDX Server:

-- 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;
CloverDX Server setup

Example of a properties file configuration:

jdbc.driverClassName=oracle.jdbc.OracleDriver
jdbc.url=jdbc:oracle:thin:@host:1521:db
jdbc.username=cloverUser
jdbc.password=cloverPassword
jdbc.dialect=org.hibernate.dialect.Oracle12cDialect

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 the privileges which have to be granted to a schema used by CloverDX Server:

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

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

arrow Continue with: Encrypted JNDI or Activation