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 Oracle
- Permissions Required for SQL Server
- 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 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 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 |
| 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 Sybase
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. Stored procedures cannot be hidden.
| No special privileges required. Stored procedures cannot be hidden.
|
| Alter Schema Object | No special privileges required. |
Enable |
| 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
The following subtopics describe the version information used when comparing, archiving, or creating a configuration standard:
- Version Information for DB2 for LUW
- Version Information for Oracle
- Version Information for SQL Server
- Version Information for Sybase
Version Information for DB2 for LUW
| Parameter | Description |
|---|---|
| INST_NAME | Name of the current instance. |
| IS_INST_PARTITIONABLE | Indicates whether the current instance is a partitionable database server instance. Possible return values are 0, if it is NOT a partitionable database server instance, and 1if it IS a partitionable database server instance. |
| NUM_DBPARTITIONS | The number of database partitions. If it is NOT a partitioned database environment, this value is 1. |
| INST_PTR_SIZE | The bit size of the current instance. Values are 32 or 64. |
| RELEASE_NUM | The internal release number as returned by the db2level command. For example, 03030106. |
| SERVICE_LEVEL | The service level as returned by the db2level command. For example, DB2 v8.1.80. |
| BLD_LEVEL | The build level as returned by the db2level command. For example, n041021. |
| PTF | The program temporary fix (PTF) identifier as returned by the db2level command. For example, U498350. |
| FIXPACK_NUM | The FixPak number as returned by the db2level command. For example, 9. |
Version Information for Oracle
On Oracle platforms, DB Change Manager provides a list of all products installed on the Oracle instance and their versions.
Version Information for SQL Server
On SQL Server, the following parameters are included:
- Product Version (e.g. 9.00.3042.00)
- Platform (e.g. NT INTEL X86)
- Language
- Physical Memory
- Processor Count
- Processor Type
- Windows Version
For entries that contain internal values, the numeric attribute is also available for standard comparisons. For example, the Product Version attribute has a character and an internal value of “8.00.2039” and 524288, respectively. DB Change Manager supplies the Product Version as “8.00.2039,” and the Product Version Internal Value as 524288.
Version Information for Sybase
On Sybase platforms, two groups of configuration parameters are supplied:
- The Server Information group displays the results of executing
sp_server_info, where the attribute name is the configuration parameter and the value is its value. - The Version Information group, which contains the following parameters:
- Build Number
- Build Type
- Compilation Date & Time
- Compilation Kernel
- Compilation OS Bit Size
- Compilation OS Platform
- EBF Version
- Post Build Type
- Product
- Product Code
- Version