ALTER LOGIN POLICY statement

Description

Modifies some or all option values for existing login policies in the database on the named multiplex server.

Syntax

ALTER LOGIN POLICY policy-name policy-options
MULTIPLEX SERVER server-name

Parameters

policy-options: policy-option [ policy-option... ] 
policy_option:
policy-option-name =policy-option-value 
policy-option-value={ UNLIMITED |  ROOT |  value }

Example

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;

Permissions

Must have DBA or USER ADMIN authority.