Using integrated logins

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

StepsUsing an integrated login

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

  2. Create an integrated login mapping between a user profile and an existing database user. This can be done using a SQL statement.

  3. 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.