Show TOC

XUSERLocate this document in the navigation structure

Use

With the XUSER command line tool, you can store user logon data (user name and password, database name) for all user types. This simplifies logon to databases.

SAP systems use XUSER for the authorization of work processes. Exception: SAP liveCache systems that use central authorization. More information: SAP note 39439 Information published on SAP site

You create XUSER entries containing the logon data and store them as user keys. When logging on to a database, you only specify the user key. XUSER entries are stored separately for each operating system user. On Microsoft Windows, they are stored in the registry, on Unix and Linux, they are stored in the file system ( .XUSER.62 in the home directory of the special operating system user for SAP MaxDB). The data can only be accessed by the operating system user who owns the data.

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 to the same database, individual user data can be managed separately.

You can call XUSER from the command line or from Database Manager CLI. Not all XUSER functions are available in Database Manager CLI however.

More information: Database Manager CLI, -ux: Logging on to the XUSER Program

XUSER can be used on all operating systems supported by the database system. It is a component of the SAP MaxDB software.

Constraints
  • Some database tools (for example Loader) and applications that use the ODBC interface cannot access XUSER data.

  • XUSER cannot be used to manage the actual users. You can only access a database using a user stored under an XUSER entry if this user has actually been created for this database.

  • For Unicode-capable databases only: You can only import Unicode user names and passwords into XUSER from a Unicode file (by using the XUSER option -b), but you cannot enter them directly on the command line.