Required settings for the Oracle database and database users

When you are creating the Oracle database, use the required settings to ensure IBM® Sterling Control Center Monitor can use the database.

Required setting Production schema More information

Character set

AL32UTF8

This setting is set as part of database instance creation.

Database user permissions

GRANT "CONNECT" TO <<productionsSchemaUser>>

GRANT CREATE TABLE TO <<productionsSchemaUser>>

GRANT CREATE VIEW TO <<productionsSchemaUser>>

GRANT "SELECT_CATALOG_ROLE" TO <<productionsSchemaUser>>

GRANT UNLIMITED TABLESPACE TO <<productionsSchemaUser>>

GRANT CREATE SEQUENCE TO <<productionsSchemaUser>>

GRANT CREATE PROCEDURE TO <<productionsSchemaUser>>

GRANT CREATE TRIGGER TO <<productionsSchemaUser>>

GRANT RESOURCE TO <<productionsSchemaUser>>

Note: This permission is mandatory for DB partition: GRANT "SELECT_CATALOG_ROLE" TO <<productionsSchemaUser>>