Entering content frame

Background documentation Creating or Changing XUSER Entries Locate the document in its SAP Library structure

You generate a new XUSER entry or change an existing XUSER entry by overwriting its data.

Note

XUSER is not a tool for managing database users. It only manages the XUSER entries for database users in the XUSER program. This program helps other tools to connect to the database instance. You can access the database instance with a user saved under an XUSER entry only if this database user has been created for this database instance with an SQL statement.

See also: Using XUSER

You do not need to connect to the XUSER program to create new XUSER entries. To change XUSER entries, you must use the data of the user in the entry you want to change, or the data in the XUSER key DEFAULT, to connect to the XUSER program.

To create or change XUSER entries, use the following command:

xuser [<options>] set

Options

-h

Display help texts

-V

Display version of XUSER program

-A ASCII8

XUSER data is interpreted as ASCII8

-b <file_name>

XUSER entries are generated in the background from the data in the file <file_name>.

See: Creating or Changing XUSER Entries in the Background

-U <user_key>

Key name under which the XUSER entry is saved in the XUSER program

Character string with a maximum of 18 characters. This character string is case-sensitive.

A predefined XUSER entry exists with the key name DEFAULT. This name cannot be changed.

If you do not specify a key name when you call XUSER, then all other information refers to the XUSER entry DEFAULT.

-u <user_name>,<password>

User name and password

Character strings each with a maximum of 18 characters

You must place them in quotation marks if they contain lowercase letters or special characters. Otherwise lowercase letters are converted to uppercase letters.

-d <database_name>

The name of the database instance you want to work on

Character string with a maximum of 18 characters

This character string is case-sensitive.

If you do not specify a <database_name>, then this name is taken from the environment variable SERVERDB.

-n <database_server>

The name of the server on which the database you called is running

Character string with a maximum of 64 characters

This character string is case-sensitive.

If you do not specify a <database_server>, then the local server is used.

-S <SQL_mode>

SQL mode

Character string with a maximum of 8 characters

If you do not specify an <SQL_mode>, then the INTERNAL SQL mode is used.

-t <timeout>

Timeout value in seconds

Possible values: -1, <number>, 0

-1: The default value of the database instance is used.
0: No timeout value is used.

If you do not specify a <timeout>, then the value –1 is used.

-I <isolation_level>

Isolation level

(for application programs and precompilers only)

If you do not specify an <isolation_level>, then the value –1 is used. This means that the default value of the database instance is used.

 

 

Leaving content frame