XUSER

Purpose

The XUSER database tool enables user log-in data to be stored and provides simplified log-on to database instances. You can use XUSER to store log-in data for database system administrators (SYSDBA users), database manager operators (DBM operators) and database users. 

XUSER is a command line tool and can be used on all operating systems supported by the database system. XUSER can be used in SAP systems.

Implementation

XUSER is part of the MaxDB software package, which you can download from the MaxDB Website (see Download and Installation Manual).

For further information about the database system, see the documentation Concepts of the Database System and the Glossary.

Integration

You can also call the XUSER program from the Database Manager CLI. Not all XUSER functions are available from here however. See Database Manager CLI, Logging-on to the XUSER program: -ux

Features

Log-on data for logging on to database instances is defined as XUSER entry data and stored under a user key.  When logging on to a database instance, you specify the user key only.

XUSER entries are stored separately for each operating system user. XUSER entries are stored in the registry in Microsoft Windows, and in the file system in UNIX/Linux.

Operating system users can define up to 32 user keys for themselves. If several users are working with the same computer but log on under different user names using one database instance, individual user data can be managed separately in such cases.

Using a User Key when Logging On to a Database Instance

Creating or Changing XUSER Entries

Displaying Data Contained in XUSER Entries

Deleting XUSER Entries

XUSER Options

Restrictions

?     Some database tools (Loader and Database Manager GUI) and applications that use the ODBC interface (such as SQL Studio) cannot access XUSER data.

?     XUSER is not used to manage the actual users. XUSER is used only to manage the XUSER entries for these users. You can only access a database instance using a user stored under an XUSER entry if this user has actually been created for this database instance. Similarly, you can only manage a database instance using a Database Manager operator stored in an XUSER entry if you have created this Database Manager operator beforehand.

?     Only for Unicode-enabled database instances: You can import user names and passwords from a file into XUSER in Unicode only by using XUSER option-b, but you cannot enter them directly into the command line.