Privileges required to compare/deploy using Schema Compare for Oracle

This article details the privileges required to compare and deploy database schema using Schema Compare for Oracle.

Selecting schemas to compare

On the Project Configuration dialog box, all schemas in a database are available to select from the Schemas list:

You do not require any privileges to select schemas for comparison.

Comparing schemas

If you are not the owner of the schemas you want to compare, the following privileges are required to compare objects:

Non-PL/SQL objects (for example TABLES, VIEWS, SYNONYMS) require the SELECT privilege
PL/SQL objects (for example PROCEDURES, FUNCTIONS, PACKAGES) require the EXECUTE privilege

If you have insufficient privileges to compare an object, it is not displayed in the comparison results. Note that a deployment script created from incomplete comparison results may fail or produce unexpected results.

Deployment

To run a deployment script created by Schema Compare for Oracle, the following system privileges may be required:

ALTER <OBJECT TYPE> or ALTER ANY <OBJECT TYPE> to alter objects
For example, ALTER ANY PROCEDURE
CREATE <OBJECT TYPE> or CREATE ANY <OBJECT TYPE> to create objects
For example, ALTER INDEX
DROP <OBJECT TYPE> or DROP ANY <OBJECT TYPE> to drop objects
For example, DROP TABLE

Note that:

if you have insufficient privileges to perform the actions in the deployment script, the script will fail
to deploy using Schema Compare for Oracle, you are recommended to have DBA privileges
if you create a deployment script to run later, you are recommended to run the script as the schema owner

Was this article helpful?

Search support