These topics describe the operations permissions and version information regarding the database management system (DBMS) or systems you use with DB Change Manager:
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.
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. |
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. |
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. |
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. |
The following subtopics describe the version information used when comparing, archiving, or creating a configuration standard:
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. |
On Oracle platforms, DB Change Manager provides a list of all products installed on the Oracle instance and their versions.
On SQL Server, the following parameters are included:
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. |
On Sybase platforms, two groups of configuration parameters are supplied:
sp_server_info
, where the attribute name is the configuration parameter and the value is its value.| | | | | | | |