Page History
...
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 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
...