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-SAP databases.

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

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.