Modifying an Existing Login Policy

Modify options within an existing login policy.

Prerequisites

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