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.
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.
xuser [<options>] set
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 |
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