Deleting a Login Policy

You cannot delete the root login policy or one currently assigned to a user.

Prerequisites
Requires the MANAGE ANY LOGIN POLICY system privilege.
Task
  1. Verify that no users are currently assigned the login policy to be dropped.
  2. To drop a login policy, execute:
    DROP LOGIN POLICY policy_name
Parent topic: Login Policies
Related reference
DROP LOGIN POLICY Statement