Product Guide › Implementing CA Access Control for Virtual Environments › Post-Deployment Tasks › How to Prepate the Central Database

How to Prepate the Central Database

CA Access Control for Virtual Environments requires a relational database management system (RDBMS). You must prepare the database before you configure CA Access Control for Virtual Environments:

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

   Note the following before installing an RDBMS:

   • For a list of supported RDBMS software, see the Release Notes.
   • You do not have to install the central database on the CA Access Control for Virtual Environments virtual machine. For information about system requirements for your RDBMS, see the documentation for your product.
2. Configure the RDBMS for CA Access Control Enterprise Management:

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

   • For SQL Server, do the following:
     • Create a new case-insensitive database.
     • Set the sort order to SQL_Latin1_General_CP1_CI_AS.
     • Create a new user, make the new database the default database of the user, and assign the user the following privileges: DBCREATOR, SYSADMIN
   • For Oracle, do the following:
     • Create a new user for the central database and assign the following privileges:

       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)

     • Grant the user additional privileges on the CA Access Control for Virtual Environments database using the following query:

       grant adminiser database trigger to <DB_USER>;

     • Set unlimited quota on the tablespace that hosts CA Access Control for Virtual Environments