Resetting Per-target Values for Connections

Use alter connection to change per-target security settings to global values set with configure replication server.

Changes take effect after you resume the connection. This procedure does not affect the configuration of use_security_services.

  1. Log in to the Replication Server and execute suspend connection at the isql prompt. Enter:
    suspend connection to dataserver.database
  2. Change security settings with alter connection. Enter:
    alter connection to dataserver.database
        set security_services to ‘default’
  3. Resume the route or connection with resume connection for the changes to take effect. Enter:
    resume connection to dataserver.database