Summary of authentication-related options
- Last Updated: October 23, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Apache Hive 8.0
- Documentation
The following tables describe the connection options used for User ID/Password and Kerberos Authentication. The connection options are listed alphabetically by the GUI name that appears on the driver Setup dialog box. The connection string attribute name is listed in parentheses. See "Connection option descriptions" for details about configuring the options.
| Option | Description |
|---|---|
| User ID/Password Authentication | |
| Authentication Method (AuthenticationMethod) | Specifies the method the driver uses to authenticate the user to the server when
a connection is established. If set to 0 (User ID/Password), the driver sends the user ID in clear text and an encrypted password to the server for authentication. If set to -1 (No Authentication), the driver sends the user ID and password in clear text to the server for authentication. If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method supports both Windows Active Directory Kerberos and MIT Kerberos environments. Default: 0 User ID/Password |
| Proxy User (ProxyUser) | Specifies the UserID used for Impersonation and
Trusted Impersonation. When impersonation is enabled on the server, this value
determines your identity and access rights to files when executing queries. Default: None. If no value is provided for this option or if impersonation is disabled, you will execute queries as the user who initiated the HiveServer process. |
| User Name (LogonID) | The default user ID that is used to connect to your
database. Default: None |
| Additional Properties for Session Cookie Based Authentication (HTTP Mode only) | |
| Cookie Name (CookieName) | Specifies the name of the cookie used for authenticating HTTP
requests when HTTP mode (TransportMode=1) and
session cookie based authentication are enabled (EnableCookieAuthentication=1). Default: If no value is specified, the driver attempts to use the following
cookie names by default: |
| Enable Cookie Authentication (EnableCookieAuthentication) | Determines whether the driver attempts to use session cookie
based authentication for requests to an HTTP endpoint after the initial authentication
to the server. Cookie based authentication improves response time by eliminating the
need to re-authenticate with the server for each request. If set to 0 (Disabled), the driver does not use cookie based authentication for HTTP requests after the initial authentication. If set to 1 (Enabled), the driver attempts to use cookie based authentication for requests to an HTTP endpoint after the initial authentication to the server. The cookie used for authentication is specified by the Cookie Name option. If the name does not match, or authentication fails, the driver attempts to authenticate according to the setting of the Authentication Method option. Default: 1 (Enabled) |
| Option | Description |
|---|---|
| Authentication Method (AuthenticationMethod) | Specifies the method the driver uses to authenticate the user to
the server when a connection is established. If set to 0 (User ID/Password), the driver sends the user ID in clear text and an encrypted password to the server for authentication. If set to -1 (No Authentication), the driver sends the user ID and password in clear text to the server for authentication. If set to 4 (Kerberos Authentication), the driver uses Kerberos authentication. This method supports both Windows Active Directory Kerberos and MIT Kerberos environments. Default: 0 User ID/Password |
| GSS Client Library (GSSClient) | The name of the GSS client library that the driver uses to communicate with the
Key Distribution Center (KDC). Default: native (the driver uses the GSS client for Windows Kerberos. ) |
| Service Principal Name (ServicePrincipalName) | The service principal name to be used by driver for
Kerberos authentication. Default: None. |
| User Name (LogonID) | The default user ID that is used to connect to your
database. Default: None |