Configuring Shared Services with Data Relationship Management User Roles

You add Oracle Data Relationship Management roles in Oracle Hyperion Shared Services by running one of the SQL scripts provided with the Data Relationship Management installation.

To add Data Relationship Management roles in Shared Services:

  1. On the server where Data Relationship Management is installed, navigate to the server\config folder, which is typically:

    C:\Oracle\Middleware\EPMSystem11R1\products\DataRelationshipManagement\server\config.

  2. Run the appropriate SQL script for the Shared Services database which was configured in the EPM configuration process: drm_roles_oracle.sql or drm_roles_sql_server.sql.
    1. Log into the database server as a user with database administrator privileges.
    2. Run the script against the Shared Services database.