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.