DROP LOGIN POLICY Statement

Removes a login policy from the database.

Syntax

DROP LOGIN POLICY policy-name

Examples

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

Usage

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

Must have DBA or USER ADMIN authority.