Creating a secure connection

You can set security parameters when you create a connection with create connection. Normally, you use this command to add connections to non-Sybase databases.

Here is the syntax for including security features with the create connection command. See create connection in the Replication Server Reference Manual for detailed information about using create connection.

create connection to data_server.database...
  set username [to] user
  [set password [to] passwd]
  [set security_mechanism [to] 'mechanism_name' |
  set dsi_exec_request_sproc [to] { 'on' | 'off' } |
  set security_mechanism [to] 'mechanism_name' |
  set security_parameter [to] { 'required' |
    'not_required' } ]

Table 8-8 describes the security parameters you can set with create connection. In addition, you can set the dsi_exec_request_sproc parameter described in Table 8-10.

Connections parameters are stored in the rs_config table in the RSSD, and you must have sa permission to execute them.

**Table 8-10: Special security parameters for connections**
security_parameter	Description
dsi_exec_request_sproc	Indicates whether request stored procedures at the primary Replication Server are “off” or “on.” Use in multiple security-system environments. Refer to “Using more than one security mechanism” for more information. Default: off

Security parameters set at both ends of a connection must be compatible. See “Planning for compatible settings” for details.