Database Guide › Database Storage and Partitioning › Customize the DDL Scripts

Customize the DDL Scripts

If required, you can customize the SQL scripts. For example, you can use tablespaces of a different name or refine the storage specifications.

Important! We strongly recommend that any changes to the Native*.sql scripts are made only under the guidance of CA Support at http://ca.com/support.

Modify the Grant_user and Synonyms scripts

(Applicable to Oracle databases only) If you want to use separate database accounts for the CA DataMinder primary user and the schema owner, modify the followng scripts by adding the actual name of the Oracle user.

Note: In all cases, specify the user name in upper case, for example, MY_DLP_USER.

Synonyms.sql

Replace all '<user>' references with the schema owner. This Oracle user owns the CA DataMinder schema tables.

Grant_user.sql

Replace all '<user>' references with the primary user. The CA DataMinder infrastructure uses this Oracle user to access the CMS database.

DWSynonynms

(Optional) Modify this script if you intend to deploy the CA DataMinder data warehouse.

Replace all '<user>' references with the schema owner. This Oracle user owns the CA DataMinder schema tables.

DWGrant_user.sql

(Optional) Modify this script if you intend to deploy the CA DataMinder data warehouse.

Replace all '<user>' references with the primary user. The CA DataMinder infrastructure uses this Oracle user to access the CMS database.

More information:

Obtain the Native DDL Scripts