Procedure documentationCreating or Changing XUSER entries Locate this document in the navigation structure


Creating New XUSER Entries

You can either create new XUSER entries interactively or import them from an XUSER file.

The DEFAULT user key already exists. As per the system default there is no data stored under this key yet. When you define the first XUSER entry, the data specified is stored under the DEFAULT user key. If you specify a key other than DEFAULT in this command, the data is stored under the specified key and under the existing DEFAULT user key as well.

Changing XUSER Entries

You change an existing XUSER entry by completely overwriting its data.

Operating system users can usually only change their own XUSER entries.


  • The operating system user that has defined the DEFAULT user key can change this XUSER entry.

  • On Microsoft Windows, an operating system user who belongs to the Administrators group can change the XUSER entries of other operating system users. This is necessary where an operating system user that exists for an XUSER entry is not able to log on to the operating system interactively.


xuser [<options>] set

XUSER: Options




The XUSER program interprets the entries as ASCII8. The default value for the character set is UTF-8.

-b <file_name>

XUSER reads the XUSER entries from the XUSER file <file_name>

More information: Importing XUSER Entries from a File

-c <domain>\<os_user>

On Microsoft Windows only; to use this option, you need administration privileges.

Changes the XUSER entry for operating system user <os_user> of the <domain>.

-d <database_name>

If you do not specify a database name, no database is assigned to the XUSER entry.

-e <encryption>

Only in SAP systems

<encryption> type used for connection to database

At present you can only select SSL for <encryption>. If you are not using encryption, omit this option.


Displays help

-l <isolation_level>

Isolation level

For application programs only

If you do not specify an <isolation_level>, the XUSER program uses the value -1.

-n <database_computer>

Name of the computer on which the database is running

The character string is case-sensitive.

If you do not specify a <database_computer>, the XUSER program uses the local computer.

-S <SQL_mode>

SQL Mode

If you do not specify an <SQL_mode>, the XUSER program uses the INTERNAL SQL mode.

-t <timeout>

Timeout value in seconds

Possible values: -1, <seconds>, 0

-1: The default value for the database is transferred to the XUSER program.

0: No timeout

If you do not specify a <timeout>, the XUSER program uses the value -1.

-U <user_key>

User key of the XUSER entry, case-sensitive

Character string with maximum of 18 characters (9 characters in Unicode)

-u <user_name>,<password>

User name (database user or DBM operator) and password

If user name or password contain lowercase letters or special characters, enclose these in quotation marks. The XUSER program otherwise converts lowercase letters to uppercase letters automatically.


Display the version of the XUSER program


As operating system user ANNA, you create an XUSER entry with the user key ag. Under this XUSER user key, you store your log-on data for the DEMODB database: DBM operator name anna_ghobadi and password may.

xuser -U ag -d DEMODB -u anna_ghobadi,may