Setting up Oracle database and database users (schemas)

When you are creating the Oracle database, use the required settings defined below for Control Center Director to use the Oracle database.

Required setting Database schema More information

Character set

AL32UTF8

This setting is set as part of database instance creation.

Database user permissions

GRANT "CONNECT" TO <<databaseSchemaUser>>

GRANT CREATE TABLE TO <<databaseSchemaUser>>

GRANT CREATE VIEW TO <<databaseSchemaUser>>

GRANT "SELECT_CATALOG_ROLE" TO <<databaseSchemaUser>>

GRANT UNLIMITED TABLESPACE TO <<databaseSchemaUser>>

GRANT CREATE SEQUENCE TO <<databaseSchemaUser>>

  
For additional settings on Oracle databases see the following links: