To change the security settings for a database connection, use alter connection.
Here is the syntax for altering security:
alter connection to data_server.database {
...
set password to passwd |
set security_mechanism to 'mechanism_name' |
set dsi_exec_request_sproc to { 'on' | 'off' } |
set security_parameter to { 'required' |
'not_required' }}
Refer to Table 8-8and Table 8-10 for a list and description of parameters you can alter.
To change the security parameters of a database connection, perform these steps at the Replication Server:
Execute suspend connection to suspend activity on the connection.
Execute alter connection to change security parameters. Set one parameter at a time.
Execute resume connection to resume activity on the connection.
