You generate a new XUSER entry or change an existing XUSER entry by overwriting its data.
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>. |
-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> |
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. If you do not specify a <timeout>, then the value –1 is used. |
-I <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. |