Page History
...
- Permissions Required for DB2 for LUW
- Permissions Required for SQL ServerOracle
- Permissions Required for OracleSQL Server
- Permissions Required for Sybase
...
| 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. |
| Anchor |
|---|
...
|
...
|
...
Oracle
No special privileges required.
Encrypted stored procedures cannot be viewed.
| Task | Permissions for Own Objects | Permissions for All Objects |
|---|---|---|
| Archive and Compare Schemas | No special privileges required. |
Encrypted stored procedures cannot be viewed.
| SELECT_CATALOG_ROLE |
| Alter Schema Object |
Permission to connect to the MSDB database.
| No special privileges |
sysadmin
On SQL Server 2000, you must enable sp_configure to allow updates, and have permission to connect to the MSDB database.| 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. |
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. |
| Anchor |
|---|
...
|
...
|
...
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. SELECT_CATALOG_ROLEEncrypted stored procedures cannot be viewed. |
| Alter Schema Object | Permission to connect to the MSDB database. No special privileges required.DBA role to alter system objectsfor 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 | DBA rolesysadmin |
| 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. |
...
| Anchor | ||||
|---|---|---|---|---|
|
...
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
IBM DB2 for LUW Version Information
...