Using Integrated Logins

You must perform several steps in order to connect via 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 (deprecated) or Integrated (the option is case insensitive), in place of the default value of Standard. )This step requires SET ANY SECURITY OPTION system privilege.
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.

• Enabling the Integrated Login Feature
  The LOGIN_MODE database option determines whether the integrated login feature is enabled. As database options apply only to the database in which they are found, different databases can have a different integrated login setting even if they are loaded and running within the same server.
• Creating an Integrated Login in SQL
  User profiles can only be mapped to an existing database user ID. When that database user ID is removed from the database, all integrated login mappings based on that database user ID are automatically removed.
• Revoking an Integrated Login Permission (SQL)
  You can remove an integrated login mapping using Interactive SQL.
• Connecting from a Client Application
  A client application can connect to a database using an integrated login in one of the following ways: