PwdWallet

TimesTen enables you to store user names and associated passwords in an Oracle Wallet. This is the most secure and preferred method of providing credentials for connecting to a TimesTen database. The PwdWallet connection attribute is the path to the location of the wallet, from which TimesTen retrieves the password for the specified user name.

You specify the wallet from which to retrieve credentials for your connection using the UID and PwdWallet connection attributes. You provide the user name to identify which credentials to retrieve from the wallet for the user that is specified.

Connect “dsn=mydb;uid=terry;PwdWallet=/home/terry/wallets/mywallet”; 

Notes

• To use PwdWallet for client/server connections, the wallet must exist on the client. You get an error if you attempt to retrieve credentials from a wallet located in the server.
• On the client side, the client process reads the stored credentials for the user ID and uses them to connect to the TimesTen server.
• If you are not using PwdWallet to specify a wallet, then use the PWD connection attribute to specify the password that corresponds with the specified UID.
• For more information on creating the wallet and managing Oracle cache administration user IDs and passwords, see Providing a User Name and Password in an Oracle Wallet in Oracle TimesTen In-Memory Database Security Guide.

Required Privilege

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

Usage in TimesTen Scaleout and TimesTen Classic

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

Setting

Set PwdWallet 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	PwdWallet	Absolute path and name of the wallet that stores the cache administration user name and password.
Windows ODBC Data Source Administrator	PwdWallet field on the Oracle TimesTen client DSN Setup dialog.

Also see ttUser