Removes a login policy from the database.
DROP LOGIN POLICY policy-name
This example creates the Test11 login policy and then deletes it.
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 user's policy assignment or DROP USER to drop the user.
Must have DBA or USER ADMIN authority.