Removes a login policy from the database.
Go to Examples
Go to Usage
Go to Permissions
DROP LOGIN POLICY policy-name
(back to top)
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.