Setting Logical Server Assignment When Altering a Login Policy Using Interactive SQL

Alter logical server assignment using Interactive SQL.

1. Connect to the database as a user with DBA or USER ADMIN authority.
2. Execute an ALTER LOGIN POLICY statement. The LOGICAL SERVER clause lets you configure values of certain login policy options on a per logical server basis.

   For example, to alter a logical server assignment by assigning logical server ls1 to the login policy lp1, enter:

   ALTER LOGIN POLICY lp1 ADD LOGICAL SERVER ls1;