Removing Logical Server Assignments

Remove all existing logical server assignments from a user-defined login policy.

To remove existing logical server assignments from a user-defined login policy, set the logical server assignment to DEFAULT. Setting the logical server assignment to DEFAULT in the root login policy restores the default assignment of OPEN logical server.

  1. Connect to the database as a user with the MANAGE ANY LOGIN POLICY system privilege.
  2. Execute an ALTER LOGIN POLICY statement that assigns the logical server to DEFAULT.

    For example, to alter a logical server assignment by assigning logical server DEFAULT to the user-defined login policy lp1, enter:

    ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER DEFAULT
Parent topic: Manage Logical Server Membership