ALTER LOGIN POLICY statement

Description

Modifies some or all option values for existing login policies in the database.

Syntax

ALTER LOGIN POLICY policy-name policy-optionsMULTIPLEX SERVER server-name ]

Parameters

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

Examples

Example 1

This example alters the Test1 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.

ALTER LOGIN POLICY Test1
locked=ON
max_connections=5;

Usage

For descriptions of login policy options, see CREATE LOGIN POLICY statement.

When a login policy is altered, changes are immediately applied to all users, except for the password_expiry_on_next_login, which does not affect current users assigned to the changed policy.

Permissions

Must have DBA or USER ADMIN authority.

See also

“Login management” in Chapter 8, “Managing User IDs and Permissions,” in the System Administration Guide: Volume 1