Configuring security for the RepAgent pathway

To set or change security parameters for the pathway that RepAgent uses to log in to Replication Server, use the sp_config_rep_agent system procedure. Refer to sp_config_rep_agent in the Replication Server Reference Manual for information about this Adaptive Server stored procedure.

To configure the RepAgent pathway, log in to Adaptive Server and execute sp_config_rep_agent at the isql prompt. Here is the syntax:

sp_configure_rep_agent dbname,
{'security mechanism' 'mechanism_name' |
'security_parameter' {'true' | 'false' }}

Table 8-7 describes the security parameters you can set with sp_config_rep_agent. They are stored in the sysattributes table of the database for which RepAgent is enabled. RepAgent parameters are dynamic. They take effect immediately and do not require a reboot of Adaptive Server. You must have sa or dbo permission to execute them.

Settings for the RepAgent pathway differ from typical Replication Server settings in two ways:

For compatibility with other Adaptive Server parameters, parameters for the RepAgent to Replication Server pathway are set to “true” or “false” instead of “required” or “not_required,” respectively. The default value of all parameters is “false.”
The RepAgent parameter that specifies whether to validate the sequence of messages received by Replication Server is msg_out_of_sequence_check and not msg_sequence_check.

To enable, or disable, network-based security at Adaptive Server, or to make other security changes at the Adaptive Server that affect RepAgent, refer to the Adaptive Server System Administration Guide.

Examples

This section provides some examples of using sp_config_rep_agent to configure security.

To require that all messages be encrypted, execute:

sp_configure_rep_agent pubs2,
   'msg confidentiality' 'true'

To change the security mechanism for the RepAgent pathway to DCE, execute:
```
sp_configure_rep_agent pubs2,
  'security mechanism' 'dce'
```