PWDCrypt

The value for PWD is stored in clear text, which does not allow special characters, in the .odbc.ini file on UNIX and Linux systems and in the Windows Registry on Windows. Any users who have access to the .odbc.ini file or Windows Registry can view the value for this attribute. The PWDCrypt attribute enables special characters, is case sensitive and contains the value of the encrypted password.

For security reasons, the PWDCrypt attribute should only be placed in User DSNs or user private ODBCINI files. The presence of the PWDCrypt in System DSNs enables any user to use the PWDCrypt value to connect to TimesTen, even though they have no knowledge of the cleartext password.

To generate the value for this attribute, run the ttUser utility.

Required Privilege

No privilege is required to change the value of this attribute.

Notes

If PWD and PWDCrypt are both supplied, TimesTen uses the value of the PWD attribute. See UID and PWD.
TimesTen does not store the value of the PWD attribute anywhere in the TimesTen system.
If you are not using PwdWallet to specify a wallet and if you want to provide an encrypted password, use PWDCrypt instead of PWD to specify an encrypted password that corresponds with the specified UID.

See Required User Authentication for Utilities in the description of UID and PWD for details about the treatment of passwords when using utilities that require specific privileges.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set PWDCrypt as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems `odbc.ini` file in TimesTen Classic or in the database definition (`.dbdef`) file in TimesTen Scaleout	`PWDCrypt`	Enter the value generated by the `ttUser` utility.
Windows ODBC Data Source Administrator	PWDCrypt field on the Oracle TimesTen client DSN Setup dialog	Enter the value generated by the `ttUser` utility.