Examples

This section provides some examples of using alter connection.

To require Replication Server to connect to the target database (TOKYO_DS.pubs2) with a credential, execute:

alter connection to TOKYO_DS.pubs2
   set unified_login to 'required'

Noteunified_login must be “required” for other security services to take effect.

To turn “off” request stored procedures at the TOKYO data server in a multiple security-system environment, execute:

alter connection to TOKYO_DS.pubs2
  set dsi_exec_request_sproc to 'off'