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

The MANAGE ANY LOGIN POLICY system privilege.

Task

Login policy names must be unique. You see an error message if the name of the login policy you are adding already exists.

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