You can use the XUSER program to define XUSER entries for database users and save them under a key name ( user_key).
XUSER entries help database tools, such as the Database Manager CLI and the C/C++ Precompiler, to connect to the database instance. SAP systems also support the use of the XUSER tool.
Other database tools, such as the Loader and the Database Manager GUI, and applications that use the ODBC interface (such as SQL Studio) cannot access XUSER data.
XUSER entries consist of a user name and user password. You can also specify options. These data and options are saved in a separate file for each operating system user. The allocation of rights in the file system guarantees that these entries can only be used and modified by the operating system user who created them. In this way, you can save user data for various tasks and for connecting to the database instance.
You can manage individual user data in this way if, for example, more than one database user is using the same computer and each user is working under a different user name.
See also: Connecting to a Database Instance
An operating system user can define up to 32 user keys. On Microsoft Windows, the XUSER data is stored in the Registry. On UNIX, the XUSER data is stored in the file .XUSER.62 in the home directory of the user.
See also:
Connecting with the XUSER Entry
Creating or Changing XUSER Entries
Displaying Data for XUSER Entries