DROP LOGIN POLICY Statement

Removes a login policy from the database.

Quick Links:

Syntax

DROP LOGIN POLICY policy-name

Examples

(back to top)

Example 1 – create and then delete the Test11 login policy:
```
CREATE LOGIN POLICY Test11; 
DROP LOGIN POLICY Test11 ;
```

Usage

(back to top)

A DROP LOGIN POLICY statement fails if you attempt to drop a policy that is assigned to a user. You can use either the ALTER USER statement to change the policy assignment of the user or DROP USER to drop the user.

Permissions

(back to top)

Requires the MANAGE ANY LOGIN POLICY system privilege.