Database Guide › Database Storage and Partitioning › Customize the DDL Scripts › Modify Grant_user.sql and Synonyms.sql

Modify Grant_user.sql and Synonyms.sql

(Applicable to Oracle databases only) If you want to use separate database accounts for the CA DLP primary user and the schema owner, you must modify the Synonyms.sql and Grant_user.sql scripts.

Synonyms.sql

Substitute <user> with the schema owner. This is the Oracle user who will own the CA DLP schema tables.

Grant_user.sql

Substitute <user> with the primary user’. This is the Oracle user that the CA DLP infrastructure will use to access the CMS database.

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

More information:

Oracle Users

Obtain the Native DDL Scripts