Upgrade Guide › How to Upgrade from CA ControlMinder r5.3 › Upgrading from CA ControlMinder r8.0SP1 › Prepare the Central Database for Enterprise Management

Prepare the Central Database for Enterprise Management

CA ControlMinder Enterprise Management requires a relational database management system (RDBMS). You set this up before you install CA ControlMinder Enterprise Management.

You have two options for setting up your database to work with CA ControlMinder Enterprise Management:

• Pre populate the central database using deployment scripts CA ControlMinder provides.

  Using this option, you separate between database preparation and CA ControlMinder Enterprise Management installation. The database administrator can review and control the changes CA ControlMinder needs to make to the database.

• Let CA ControlMinder Enterprise Management prepare the central database during installation.

  Using this option, the CA ControlMinder Enterprise Management installation populates the database as part of the installation process.

Follow these steps:

1. If you do not already have one, install a supported RDBMS as the central database.

   Note: For a list of supported RDBMS software, see the Release Notes.

2. Configure the RDBMS for CA ControlMinder Enterprise Management:

   Verify that the database can be accessed locally and from a remote client.

   • For Oracle, create a user for the central database.

     This user must have the following permissions and settings:

     • CONNECT (granting the following system privileges: ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW)
     • RESOURCE (granting the following system privileges: CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE)
     • Unlimited quota on the tablespace that hosts the CA ControlMinder Enterprise Management Server.
   • For SQL Server:
     • Create a new case-insensitive database.

       The database must have the sort order SQL_Latin1_General_CP1_CI_AS.

     • Create a user, make the new database the default database of the user, and assign the user to the following privileges: DBCREATOR, SYSADMIN
3. (Optional) Pre populate the central database using the deployment scripts CA ControlMinder provides.
   1. Customize the deployment scripts before you deploy them.

      The deployment scripts define four default user accounts that CA ControlMinder Enterprise Management uses (superadmin, selfreguser, neteautoadmin, [default user]). You can change the names of these default accounts and their passwords.

      Important! Customize the scripts only if you plan to use the embedded user store. If you use Active Directory, CA ControlMinder Enterprise Management does not store account information in the central database. For more information, refer to the Implementation Guide.

   2. Deploy the deployment scripts.
   3. Configure the database user that you use for CA ControlMinder Enterprise Management installation.
      • For Oracle, keep the CONNECT and RESOURCE roles for the user you created.
      • For SQL Server, create a user, selecting the database that you created earlier as default, map the user to the database, and set the following permissions: CONNECT.SELECT, INSERT, DELETE, UPDATE, EXECUTE.