ASA Database Administration Guide
Connecting to a Database
Using integrated logins
Using integrated logins
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.
The LOGIN_MODE database option accepts one of following three values (which are case insensitive).
Standard With this setting, integrated logins are not permitted. This is the default setting. An error occurs if an integrated login connection is attempted.
Mixed With this setting, both integrated logins and standard logins are allowed.
Integrated With this setting, all logins to the database must be made using integrated logins.
| Caution 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 exception to this is users with DBA authority (full administrative rights). |
The following SQL statement sets the value of the LOGIN_MODE database option to Mixed, allowing both standard and integrated login connections:
SET OPTION Public.LOGIN_MODE = Mixed