Database Users and Owners

TimesTen authenticates user names with passwords. Applications should choose one UID for the application itself because by default the login name that is being used to run the application becomes the owner of objects in the database.

If you omit the UID connection attribute in the connection string, TimesTen uses the current user's login name. TimesTen converts all user names to upper case characters. Ensure that you use the fully qualified name of a database object, for example owner.table_name, whenever you issue a SQL statement.

Users cannot access TimesTen databases as user SYS. TimesTen determines the user name by the value of the UID connection attribute, or if not present, then by the login name of the connected user. If a user's login is SYS, set the UID connection to override the login name.