Upgrade Guide › Upgrading Databases › Pre-upgrade Database Considerations › Oracle Issues

Oracle Issues

Be aware of the following issues:.

Oracle users need extra privilege

Before upgrading your CMS from 12.0, you must manually grant the following privilege to your Oracle primary user and, if specified, the schema owner:

• CREATE MATERIALIZED VIEW

This privilege is granted automatically if upgrading from 14.0 or later.

CREATE SESSION Privilege

The CREATE SESSION privilege is granted directly to New Search User accounts created for CA DataMinder 14.1 or later. Search User accounts created for earlier versions of CA DLP were granted this privilege indirectly via the CONNECT ROLE.

For a full list of required privileges, see the Database Guide; search for ‘privileges’.