Modifies some or all option values for existing login policies in the database on the named multiplex server.
ALTER LOGIN POLICY policy-name policy-options MULTIPLEX SERVER server-name
policy-options: policy-option [ policy-option... ]
policy_option:
policy-option-name =policy-option-value
policy-option-value={ UNLIMITED | ROOT | value }
The following example alters the MpxUsers login policy. This example changes the locked and max_connections options. The locked value indicates that users with the policy are prohibited from establishing new connections and the max_connections value indicates the number of concurrent connections allowed on the named multiplex server.
ALTER LOGIN POLICY MpxUsers locked=ON max_connections=4 MULTIPLEX SERVER mpxsrv1;
Must have DBA or USER ADMIN authority.