Creating a New Login Policy

Any options that are not explicitly set when creating a login policy inherit their values from the root login policy..

Prerequisites

Requires the MANAGE ANY LOGIN POLICY system privilege.

Task

To create a new login policy, execute:

CREATE LOGIN POLICY policy_name {login_policy_options}

Example:

This statement creates the Test1 login policy with PASSWORD_LIVE_TIME option set to 60 days:

CREATE LOGIN POLICY Test1
password_life_time=60