1. Security Guide
  2. Authentication in TimesTen
  3. Overview of TimesTen Users

Overview of TimesTen Users

To protect access to a TimesTen database, users must be created with appropriate passwords.

There are these types of users in TimesTen:

  • Administrative users: The instance administrator is the user who created the TimesTen instance. The instance administrator must be a member of the TimesTen users group and has full privileges within the instance. See Instance Administrator and Understanding the TimesTen Users Group in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide.

    Other uses can have administrative capabilities by being granted the ADMIN privilege. This can be granted by the instance administrator or by another user with ADMIN privilege.

    Note:

    See Administrative Privileges.

  • TimesTen system users: The system users SYSTEM (for internal use), SYS (a schema for system objects), and TTREP (for replication) are created during TimesTen installation, for internal use only.

  • Internal users: An internal user and associated password are defined within a TimesTen database. The user must authenticate with the specified password for access to that database. You can create an internal user with the CREATE USER statement.

  • External users: An external user is created within the operating system but must be a member of the TimesTen users group. External users are assumed to have been authenticated by the operating system upon login, so there is no stored password within the database. TimesTen uses the operating system credentials of the external user to enable connection to TimesTen as that user. An external user must be identified to the database through the CREATE USER ... IDENTIFIED EXTERNALLY statement.

    An external user cannot connect over a TimesTen Client/Server connection unless the client and server are on the same host.

Note:

  • See Understanding the TimesTen Users Group in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide and CREATE USER in Oracle TimesTen In-Memory Database SQL Reference.

  • When an external user connects from a Linux or UNIX system, TimesTen converts the user name to upper case, rendering it case-insensitive.