Entering content frame

Procedure documentation Creating or Changing XUSER Entries: -us Locate the document in its SAP Library structure

Use

Option in the Database Manager CLI.

In the program XUSER, you can create new XUSER entries or change existing entries.

Note

XUSER is not a tool for administering database users. It administers only the XUSER entries for database users in the XUSER program, which simplify the creation of a connection to the database instance for other tools. You can only access the database instance with a user stored under an XUSER entry if the database user is actually created for this database instance with an SQL statement, either beforehand or afterwards.

Recommendation

We recommend that you use the XUSER tool directly.

See also: Using XUSER

You do not need to log on to the XUSER program to create new XUSER entries. To change XUSER entries, you must log on with the data of the user in the entry to be changed, or with the data under the XUSER key DEFAULT.

You can store new XUSER entries as a combination of the name of the database instance and the database server or as XUSER keys.

If you store the user data as a combination of the name of the database instance and the name of the database server, you can omit the specification of the user name and password (option –u) in subsequent DBMCLI calls for this database instance, since the Database Manager CLI takes the required data from the XUSER entries.

Syntax

-us <new_userid>,<new_password>

Example

Log on with the data of the user to be changed (it is not necessary to log on when creating new user data), and store the data as a combination of database and server names

[-u <user_name>,<password>] -d <database_name> [-n <database_server] -us <new_user_name>,<new_password>

 

Log on with the user data stored under the XUSER key DEFAULT (it is not necessary to log on when creating new user data), and store the data as a combination of database and server names

[-ux <default_userkey>] -d <database_name> [-n <database_server>] -us <new_user_name >,<new_password>

 

Log on with the data of the user to be changed (it is not necessary to log on when creating new user data), and store the data as an XUSER key

[-u <user_name>,<password>] -uk <user_key> -us <new_user_name>,<new_password>

 

Log on with the user data stored under the XUSER key DEFAULT (it is not necessary to log on when creating new user data), and store the data as an XUSER key

[-ux <default_userkey>] -uk <user_key> -us <new_user_name>,<new_password>

 

Leaving content frame