Providing User Credentials When Connecting

User names and their respective passwords are required when connecting to the TimesTen database.

Supply the user credentials in the connection string either by:

• Providing them from within an Oracle Wallet. This method requires you to first save the credentials in an Oracle Wallet with the ttUser utility. After creating the wallet, the particular wallet is identified by UID and PWDWallet connection attributes on the connection string. This is the preferred method as it is more secure. See Connect Using an Oracle Wallet with Credentials.

• Providing the user name and password on the connection string. Specify the user name in the UID connection attribute and specify the user password in the PWD or PWDCrypt connection attributes. See Connect Using Connection Attributes for Credentials.

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.

Connect Using Connection Attributes for Credentials

You can set user names and passwords by providing them with individual connection attributes, which can be used for connecting to a database. However, please note that the preferred and most secure method is to provide credentials from within an Oracle Wallet.

In the connection string, specify the user name in the UID connection attribute. Specify the password in the PWD connection attribute.

% ttIsql "DSN=mydb;UID=sampleuser;PWD=samplepwd"