Implementation Guide › Installing the Enterprise Management Server › How to Prepare the Enterprise Management Server › Prepare the Central Database for Enterprise Management › Customize the Central Database Deployment Scripts

Customize the Central Database Deployment Scripts

The deployment scripts define four default user accounts that CA Access Control 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 Access Control Enterprise Management does not store account information in the central database.

To customize the central database deployment scripts

1. Insert the appropriate CA Access Control Premium Edition Server Components DVD for your operating system into your optical disc drive.
2. Copy the deployment script for your RDBMS to a temporary local folder.

   By default, the database deployment scripts are located on the optical media at the following location:

   • Oracle: /Scheme/ORACLE/AC125_oracle_script.sql
   • SQL Server: /Scheme/MSSQL/AC125_mssql_script.txt
3. Edit the script as follows:
   1. Locate the Table : TBLUSERS section.
   2. Edit each line that defines a user to (INSERT INTO tblusers ...) to change the account name and password as required.
4. Save and close the script.

   The customized script can now be deployed.

Example: Customize the CA Access Control RDBMS Deployment Scripts

This example uses code snippets that are common to the Microsoft SQL Server and Oracle Database deployment scripts. In this example, you customize the script to change the default user account superadmin and password to one of your choosing.

The following snippet sets the default CA Access Control Enterprise Management super user if you use the RDBMS as your user store:

INSERT INTO tblUsers (ID,loginid, lastname, firstname, password) VALUES (1,'superadmin', 'Admin','Super', 'test')

The SQL command creates a user account called superadmin (first name Super, last name Admin) with the password test.

In the snippet you edit, you modify the user account to be called sysadmin and assign it with the password C0mp!ex.

INSERT INTO tblUsers (ID,loginid, lastname, firstname, password) VALUES (1,'sysadmin', 'Admin','System', 'C0mp!ex')