Altering a Logical Server Assignment

Add one or more user-defined logical servers to a login policy. A check prevents membership overlap among the logical servers assigned to the login policy.

Prerequisites

Database Version	Logical Server Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. MULTIPLEX ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE MULTIPLEX system privilege.

The SAP Sybase IQ resource is authenticated and running.
You are licensed for the Multiplex Grid option (IQ_MPXNODE), if running secondary servers.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > Login Policies.
Select the login policy from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties
The Login Policy Properties view appears.
Note:
- When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
- If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
(Optional) On the General Properties page, enter a comment for this login policy.

In the left pane, click Logical Server Assignment and specify:

Option	Description
Which logical servers do you want to add to this login policy?	CUSTOM – Allows access to OPEN and user-defined logical servers. DEFAULT – Inherits the logical server assignment of the root login policy. NONE – Disallows access to all logical servers. SERVER – Allows access to any multiplex node. MPX authority is required to connect.
Modify logical server assignment for a login policy	Select the logical servers to add to the login policy.

Option

Description

Which logical servers do you want to add to this login policy?

CUSTOM – Allows access to OPEN and user-defined logical servers.

DEFAULT – Inherits the logical server assignment of the root login policy.

NONE – Disallows access to all logical servers.

SERVER – Allows access to any multiplex node. MPX authority is required to connect.

Modify logical server assignment for a login policy

Select the logical servers to add to the login policy.

Click OK.