Modifying an Existing Login Policy

Use Interactive SQL to change the options for an existing login policy.

Prerequisites

Requires the MANAGE ANY LOGIN POLICY system privilege.

Task

To alter the options of an existing login policy, execute:

ALTER LOGIN POLICY policy-name {login_policy_options}

Example:

This statement alters the LOCKED and MAX_CONNECTIONS options on the Test1 login policy:

ALTER LOGIN POLICY Test1 
locked=on
max_connections=5