Release Notes › Support Utilities › Oracle User Scripts and Associated SPs

Oracle User Scripts and Associated SPs

When you install your CMS, the CA DLP server installation wizard lets you specify the database accounts that CA DLP needs to access the CMS database. However, if you intend to use an Oracle as your database engine, you can run the following scripts and SPs (stored procedures) to manually specify your Oracle primary user and schema owner prior to installing the CMS.

• CreateOracleUser.sql: Run this script to create the primary user and (if required) schema owner. The primary user is the main CA DLP database account; the infrastructure uses this account to access the CMS database.
• WgnSetupOwner.sql: This file contains a stored procedure that is installed and invoked by CreateOracleUser.sql.

For further details about manually configuring your CA DLP database accounts, see the Database Guide.

More information:

Oracle CMS Native Scripts: Native_Wrapper.sql