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

Procedure

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.

Exceptions:

  • 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.

Syntax

xuser [<options>] set

XUSER: Options

Option

Description

-A

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>

Available on Microsoft Windows only,

Operating system users <os_user> in the <domain>, for which the XUSER entry is changed.

You need administration rights in order to use this option.

-d <database_name>

If you do not specify a database name, no database will be 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.

-h

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

Character string with a maximum of 64 characters

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

Character string with a maximum of 8 characters

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

Character strings with a maximum of 18 characters (UNICODE: 9 characters)

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

-V

Display the version of the XUSER program

Example

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