Oracle Audio Technologies B31679-01 manual TimesTen instance users, Internal user, External user

Note: All examples in the TimesTen documentation set use the name timesten to represent the instance administrator.

For details on establishing the TimesTen instance administrators group, see “Create the TimesTen instance administrators group” on page 37.

On Windows systems, the user System automatically becomes the TimesTen instance administrator when Access Control is selected at install time.

On UNIX systems, a TimesTen instance administrator user is the OS user who installs that instance of Timesten.

TimesTen instance users

TimesTen instance users are user names that have been identified to the instance. They are defined at the instance level and apply to all data stores in an instance. Initially, only one user name is known to the instance: the instance administrator.

Only the instance administrator has permission to create or delete users. Individual users have permission to change their own passwords.

Instance users may be internal user names or external user names.

Internal user

A user name that has been defined within the TimesTen instance is referred to as an “internal user.” It has no significance outside of the particular instance of TimesTen in which it was defined. Internal users are authenticated by the TimesTen instance. See "CREATE USER"in the Oracle TimesTen In-Memory Database SQL Reference Guide. TimesTen user names (as specified in the UID DSN attribute) are automatically converted to upper case (case insensitive).

External user

A user name that is identified by the operating system or some other external mechanism is referred to as an “external user.” In this release only the operating system user name is recognized as an external user. External users are assumed to have been authenticated by some external mechanism. See "CREATE USER"in the Oracle TimesTen In-Memory Database SQL Reference Guide. A password is not required by TimesTen since the user was authenticated by the operating system at login time.

UNIX external user names are case sensitive. Windows external user names are not. When connecting from UNIX platforms, TimesTen

10Oracle TimesTen In-Memory Database Installation Guide