Setting up integrated logins

Several steps must be implemented in order to connect successfully via an integrated login.

To use an integrated login

  1. Enable the integrated login feature in a database by setting the value of the login_mode database option to include Integrated (the option is case insensitive), in place of the default value of Standard. This step requires DBA authority.

  2. Create a database user to map the integrated login to (if one does not already exist). This can be done using a SQL statement or a wizard in Sybase Central. This step requires DBA authority.

  3. Create an integrated login mapping between a Windows user or group profile and an existing database user. This can be done using a SQL statement or a wizard in Sybase Central. In Sybase Central, all users with integrated login permission appear in the Login Mappings folder. This step requires DBA authority.

  4. Connect from a client application in such a way that the integrated login facility is triggered.

Each of these steps is described in the sections below.


Enabling the integrated login feature
Creating an integrated login
Revoking integrated login permission
Connecting from a client application