ALTER LOGIN POLICY statement

ALTER LOGIN POLICY policy-name policy-options

policy options :
policy-option [ policy-option ... ]

policy-option :
policy-option-name = policy-option-value

policy-option-value : 
{ UNLIMITED 
| DEFAULT 
| legal-option-value }

policy-name The name of the login policy. Specify root to modify the root login policy.
policy-option-name The name of the policy option. To view a list of default login policy option names and descriptions, see the Remarks section of CREATE LOGIN POLICY statement.
policy-option-value The value assigned to the login policy option. If you specify UNLIMITED, no limits are used. If you specify DEFAULT, the default limits are used. To view a list of default login policy option values, see the Remarks section of CREATE LOGIN POLICY statement.

When a login policy is altered, changes are immediately applied to all users.

DBA authority

None.

SQL/2008 Vendor extension.

The following example alters the Test1 login policy. This example changes the locked and max_connections options. The locked value indicates that users with the policy cannot establish new connections and the max_connections value limits the number of concurrent connections that are allowed.

ALTER LOGIN POLICY Test1 
locked=ON
max_connections=5;

ALTER LOGIN POLICY statement

Syntax

Parameters

Remarks

Permissions

Side effects

See also

Standards and compatibility

Examples