User Data and XUSER 

Using the tool XUSER, you can predefine and save user data (using XUSER). You can access your XUSER data when you call the Database Manager CLI or a precompiler program or when you start an SAP system. In this case, the user would use the data stored under a certain user key (user_key).

·        Windows 2000/Windows XP: You can manage individual user data in this way if, for example, more than one database user is using the same Windows PC and each user is logging on under a different name.

·        UNIX: You can manage individual user data in this way if, for example, more than one database user is using the same HOME directory and each user is logging on under a different name.

Procedure

...

...

       1.      The database administrator (DBA operator) sets up a database user using the relevant CREATE USER statement.

       2.      The database administrator informs the operating system user what this database user’s data is.

       3.      The operating system user saves the database user’s data using XUSER.

Result

When the Database Manager CLI or the C/C++ Precompiler is now called using the option -U <user_key>, the system uses the data that was defined in user_key using XUSER. Enter the user key exactly as it was defined in XUSER, that is, your entries are case-sensitive.

Applications such as SAP DB Loader and Database Manager GUI and applications that use the ODBC interface (for example, SQL Studio) have no way of accessing XUSER data.