Modifying Security for a Connection

Use alter connection to change the security settings for a database connection.

Syntax:

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' }}

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 a security parameter.

Note: Set one parameter at a time.
Execute resume connection to resume activity on the connection.

Examples of Using alter connection to Configure Security

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'
```
Note: unified_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'
```