Show TOC

Component documentationXUSER Locate this document in the navigation structure

 

With the XUSER command line tool, you can store user log-on data for all user types. This simplifies logon to databases.

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.

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 (Loader and Database Manager GUI) and applications that use the ODBC interface (such as SQL Studio) 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.