UID and PWD

A user ID and password must be provided by a user who is identified internally to TimesTen. Alternatively, an encrypted password can be supplied using the PWDCrypt attribute. Some TimesTen operations prompt for the UID and PWD of the user performing the operation.

For client/server applications, specify UID and PWD either in the Client DSN configuration or in the connection string. The UID and PWD values specified in a connection string take precedence over the values specified in the Client DSN configuration.

Generally, when no UID connection attribute is given, the UID is assumed to be the user name identified by the operating system, and TimesTen does not prompt for a password.

When caching Oracle database tables, PWD specifies the TimesTen password while OraclePWD specifies the Oracle password.

Note:

You can set user names and passwords in connection strings or DSN definitions with the UID and PWD connection attributes, and encrypt passwords with the PWDCrypt connection attribute. However, we recommend you store your passwords in wallets. See ttUser for more information.

Required User Authentication for Utilities

All utilities that require a password prompt for one.

If a UID connection attribute is given but no PWD attribute is given, either through a connection string or in the ODBCINI file for the specified DSN, TimesTen prompts for a password. When explicitly prompted, input is not displayed on the command line.

A password given on the command line, before TimesTen prompts for the password, is visible to the ps command, so use of the PWD connection attribute is not recommended in the first call to the utility. For example, the following usage is not recommended:

% ttIsql -connStr "DSN=mydsn;UID=terry;PWD=secret";

Generally, when no UID connection attribute is given, the UID is assumed to be the user name identified by the operating system, and TimesTen does not prompt for a password.

When a utility accepts a DSN, connection string or database path as a parameter, specify the value at the end of the command line.

Required Privilege

No privilege is required to change the values of these attributes.

Usage in TimesTen Scaleout and TimesTen Classic

These attributes are supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set UID and PWD 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	`UID`	Character string specifying the user ID.
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	`PWD`	Character string specifying the password that corresponds to the user ID.
Windows ODBC Data Source Administrator	User ID and Password fields on the Oracle TimesTen Client DSN Setup dialog	Character string specifying the user ID.