LOGIN_MODE option

Function

Controls the use of integrated logins for the database.

Allowed values

Standard, Mixed, or Integrated

Scope

Can be set only for the PUBLIC group. Takes effect immediately.

Default

Standard

Description

This option specifies whether integrated logins are permitted. One of following three values are accepted (the values are case insensitive):

WARNING! Setting the LOGIN_MODE database option to Integrated restricts connections to only those users who have been granted an integrated login mapping. Attempting to connect using a user ID and password generates an error. The only exceptions to this are users with DBA authority (full administrative rights).

For more information on integrated logins see Chapter 3, “Sybase IQ Connections” in the Sybase IQ System Administration Guide.