Database Accounts for EPM System Deployment

Create the following database accounts to support new Oracle Enterprise Performance Management System deployments:

• One account for EPM System Repository

• One account for a Oracle Hyperion Planning application

  Each Planning application requires a separate database account. Before creating a Planning application, you must create a database account for it.

• One account for a Oracle Hyperion Profitability and Cost Management application

Database Roles and Privileges for EPM System Accounts

• CREATE ANY SYNONYM

• CREATE CLUSTER

• CREATE INDEXTYPE

• CREATE PROCEDURE

• CREATE SEQUENCE

• CREATE SESSION

• CREATE TABLE

• CREATE TRIGGER

• CREATE TYPE

• CREATE VIEW

• DROP ANY SYNONYM

Grant privileges to users by entering the following command:

grant CREATE ANY SYNONYM, CREATE CLUSTER, CREATE INDEXTYPE, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, DROP ANY SYNONYM to <epm_user>;

Other Settings

• EPM System database accounts must be created in a tablespace with a minimum initial capacity of 1 GB

• Extends by 500 MB

• Auto Extend set to ON

• Minimum 1 GB temporary tablespace