Login Policies

A login policy defines the rules that SAP Sybase IQ follows to establish user connections. Each login policy is associated with a set of options called login policy options.

Login management commands that you execute on any multiplex server are automatically propagated to all servers in the multiplex. For best performance, execute these commands, or any DDL, on the coordinator.

• Modifying the Root Login Policy
  You can modify the option values for the root login policy, but you cannot drop the policy.
• Creating a New Login Policy
  Any options that are not explicitly set when creating a login policy inherit their values from the root login policy..
• Modifying an Existing Login Policy
  Use Interactive SQL to change the options for an existing login policy.
• Displaying a List of Users Assigned a Login Policy
  Before you can drop a login policy, ensure that it is not currently assigned to any users.
• Deleting a Login Policy
  You cannot delete the root login policy or one currently assigned to a user.
• Assigning a Login Policy When Creating a New User
  If you do not assign a login policy when creating a user account, the account is assigned the root login policy.
• Assigning a Login Policy to an Existing User
  Use Interactive SQL to assign a login policy to an existing user.