Create a Secure Connection

You can set security parameters when you create a connection with create connection.

Normally, you use create connection to add connections to non-Sybase databases.

Here is the syntax for including security features with the create connection command. See Replication Server Reference Manual > Replication Server Commands > create connection 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' } ]

In addition to security configuration parameters you can set with create connection, you can set the dsi_exec_request_sproc special security parameters.

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

Security parameters set at both ends of a connection must be compatible.