The SECURITY environment variable specifies the security operations that are performed when the Informix JDBC client and Informix database server exchange data. The only setting for the SECURITY environment variable supported in IBM Informix JDBC Driver is PASSWORD.
If PASSWORD is specified, the user-provided password is encrypted using 56-bit encryption when it is passed from the client to the database server. There is no default setting.
Here is an example:
String URL = "jdbc:informix-sqli://158.58.10.171:1664:user=myname;
password=mypassord;INFORMIXSERVER=myserver;SECURITY=PASSWORD";
PASSWORD is case insensitive. You can type it in upper or lowercase letters.
The SECURITY=PASSWORD setting is supported in the 7.31, 8.3 and later, and 9.x and later versions of the Informix database server. The connection is rejected if used with any other versions of the server.
If the SECURITY=PASSWORD setting is specified in the IBM Informix JDBC client, the SPWDCSM csm option must be enabled on the Informix database server. Otherwise, an error is returned during connection.
To use the SPWDCSM csm server option, which supports password encryption on the database server, you must configure the server's sqlhosts servername option. After this option is set on the server, only clients using the SECURITY=PASSWORD setting can connect to that server name.
To see if the SPWDCSM csm option is supported for your version of Informix database server, or for general details on how to configure the CSM options, see the IBM Informix: Administrator's Guide for your database server.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]