Connect Using an Oracle Wallet with Credentials

You can provide credentials by saving them in an Oracle Wallet, which then can be used for connecting to the database. This is the preferred method as it is more secure.

The following creates the Oracle Wallet mywallet in the /home/terry/wallets directory. Assuming that /home/terry/wallets/mywallet does not exist, run the ttUser -setPwd command to save credentials for the user terry into the Oracle Wallet /home/terry/wallets/mywallet.

% ttUser -setPwd -wallet /home/terry/wallets/mywallet -uid terry
Enter password: 

After the credentials are saved within an Oracle Wallet, you specify the wallet from which to retrieve credentials for your connection specifying the user name with the UID connection attribute and the location and name of the Oracle Wallet with the PwdWallet connection attribute.

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

When the PwdWallet connection attribute is provided, the credentials are retrieved from the wallet specified. For client/server connections, the wallet must exist on the client.

See Providing Both Cache Administration Users and Passwords in Oracle TimesTen In-Memory Database Security Guide for more information on providing cache credentials. See PwdWallet and ttUser in Oracle TimesTen In-Memory Database Reference.