You can change all of your per-target security values for connections or routes using the set security_services to ‘default’ option.
Use alter connection to change per-target security settings to global values set with configure replication server.
Follow this procedure:
Log in to the Replication Server and execute the suspend connection command at the isql command. Here is the syntax:
suspend connection to dataserver.database
Change security settings with the alter connection command. Here is the syntax:
alter connection to dataserver.database set security_services to ‘default’
Resume the route or connection with the resume connection command for the changes to take effect. Here is the syntax:
resume connection to dataserver.database
Changes take effect after you resume the connection. This procedure does not affect the configuration of use_security_services.
Use the set security_services to 'default' parameter with alter route to change per-target security settings to global values set with configure replication server.
Follow this procedure:
Suspend the route. Enter:
suspend route to dest_replication_server
Alter the route. Enter:
alter route to dest_replication_server set security_services to 'default'
Resume the route. Enter:
resume route to dest_replication_server
Changes take effect after you resume the route. This procedure does not affect the configuration of use_security_services.
