DROP LOGIN POLICY statement

Drops a login policy.

Syntax

DROP LOGIN POLICY policy-name

Parameters

policy-name
The name of the login policy.

Remarks

The statement fails if you drop a policy that is assigned to a user. You cannot drop the root login policy. Use the ALTER USER statement to change a user's policy assignment.

Privileges

You must have the MANAGE ANY LOGIN POLICY system privilege.

Side effects

None.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example creates a login policy, Test11, and then deletes it.

CREATE LOGIN POLICY Test11;
DROP LOGIN POLICY Test11;