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

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.