ALTER LOGIN POLICY statement

Use this statement to alter an existing login policy.

Syntax
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 
| root 
| legal-option-value }
Parameters
  • 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.

Remarks

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

Permissions

Must have DBA authority.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Examples

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