On most computer systems, a password is used to prove a user's identity. This password often is transmitted over the network and can be intercepted by malicious hackers. Because this password is the one secret piece of information that identifies a user, anyone knowing a user's password can effectively be that user. Authentication methods protect the identity of the user.
The drivers support the following authentication methods:
User ID/password authentication authenticates the user to the database using a database user name and password.
Kerberos is a trusted third-party authentication service. The drivers support both Windows Active Directory Kerberos and MIT Kerberos implementations for Apache Hive, DB2, Oracle, and Sybase. For Microsoft SQL Server, the drivers support Windows Active Directory Kerberos only.
Client authentication uses the user ID of the user logged onto the system on which the driver is running to authenticate the user to the database. The database server relies on the client to authenticate the user and does not provide additional authentication.
NTLM authentication is a single sign-on OS authentication method.
The following tables describe the authentication methods supported by the drivers.
Table 13. Authentication Methods Supported by DataDirect Connect for JDBC
1 Not supported when connecting to a HiveServer1 server.
See the appropriate driver chapter for details about configuring authentication. See Required Permissions for the Java 2 Platform for information about granting permissions for Kerberos authentication.