One or more of: Standard, Integrated, Kerberos, LDAPUA, CloudAdmin, Mixed (deprecated)

Standard

Can only be set for PUBLIC. You must have the SET ANY SECURITY OPTION system privilege to set this option. Takes effect immediately.

This option specifies whether standard, integrated, Kerberos, LDAP, and CloudAdmin user authentication is permitted. One or more of the following login modes are accepted (the values are case insensitive):

If you specify multiple login modes, the database server allows all the specified modes.

You can specify multiple values in a comma-separated list. This list cannot contain white space. For example, the following setting allows both standard and integrated logins:

SET OPTION PUBLIC.login_mode = 'Standard,Integrated';

If a database file is not secured and can be copied by unauthorized users, the temporary PUBLIC login_mode option should be used (both for integrated and Kerberos user authentication). This way, integrated and Kerberos logins are not supported by default if the file is copied.

• Windows integrated logins
• Kerberos authentication
• LDAP user authentication
• -al database server option
• Security considerations: User IDs
• Security concerns: Copied database files
• Propriété de connexion login_mode

Enable only integrated user authentication (standard, Kerberos, and LDAP user authentication fails):

SET OPTION PUBLIC.login_mode = 'Integrated';

Enable standard and Kerberos user authentication (integrated and LDAP user authentication fails):

SET OPTION PUBLIC.login_mode = 'Standard,Kerberos';

Enable standard, integrated, Kerberos, and LDAP user authentication:

SET OPTION PUBLIC.login_mode = 'Standard,Integrated,Kerberos,LDAPUA';