Removes a login policy from the database.
DROP LOGIN POLICY policy-name
CREATE LOGIN POLICY Test11; DROP LOGIN POLICY Test11 ;
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.
Requires the MANAGE ANY LOGIN POLICY system privilege.