These topics describe the operations permissions and version information regarding the database management system (DBMS) or systems you use with DB Change Manager:
DBMS Operations Permissions
When DB Change Manager performs operations based on data source comparisons, there are minimal permissions required in some cases, dependent on data source platform and the action itself.
- Permissions Required for DB2 for LUW
- Permissions Required for SQL Server
- Permissions Required for Oracle
- Permissions Required for Sybase
Permissions Required for DB2 for LUW
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare | ||
| Schemas Alter Schema | ||
| Object Configuration | ||
| Settings | ||
| Compare Data | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
| Synchronize/Mask/Move Data | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
Permissions Required for SQL Server
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. Encrypted stored procedures cannot be viewed. | No special privileges required. Encrypted stored procedures cannot be viewed. |
| Alter Schema Object | Permission to connect to the MSDB database. No special privileges for objects owned by the user. | sysadmin On SQL Server 2000, you must enable sp_configure to allow updates, and have permission to connect to the MSDB database. |
| Configuration Settings | Not applicable | sysadmin |
| Compare Data | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. Cannot view encrypted stored procedures. | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. Cannot view encrypted stored procedures. |
| Synchronize/Mask/Move Data | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
Permissions Required for Oracle
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. | SELECT_CATALOG_ROLE |
| Alter Schema Object | No special privileges required. | DBA role to alter system objects |
| Configuration Settings | Not applicable | DBA role |
| Compare Data | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
| Synchronize/Mask/Move Data | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
Permissions Required for Sybase
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. Stored procedures cannot be hidden. syscomment.text read must be allowed in order to compare or archive stored procedures. | No special privileges required. Stored procedures cannot be hidden. syscomment.text read must be allowed in order to compare or archive stored procedures. |
| Alter Schema Object | No special privileges required. | sa_role Enable sp_configure allow updates |
| Configuration Settings | Not applicable | sa_role |
| Compare Data | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. The compression comparison function is unavailable for Sybase at this time. | Select privilege on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. The compression comparison function is unavailable for Sybase at this time. |
| Synchronize/Mask/Move Data | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. | Insert/Update/Delete privileges on the relevant tables and views. Schema archive permissions on the database or schema objects used in the job. |
Version Information Reference
...
IBM DB2 for LUW Version Information
...
Oracle Version Information
...
SQL Server Version Information
...
Sybase Version Information
...