Background documentation-ud: Deleting XUSER Entries Locate this document in the navigation structure

 

You use the DBM option -ud to delete the data and corresponding XUSER entry for a database user in the XUSER program.

To delete this data, you have to log on to XUSER either with the data of the database user to be deleted or with the user data registered under the user key DEFAULT.

To identify the user whose data is to be deleted, specify a combination of the name of the database instance and the database computer, or a user key.

Recommendation Recommendation

We recommend that you use the XUSER tool directly.

End of the recommendation.

Note Note

Unlike user names and passwords, the Database Manager treats user keys as case sensitive.

End of the note.

Structure

-ud

Example

Call the Database Manager CLI, log on as the user to be deleted - DAVID - with the password BLUE in the XUSER program.

To identify the user to be deleted, enter a combination of the database name DEMODB and the computer name GENUA:

>dbmcli -u <user_name>,<password> -ud -d <database_name> [-n <database_computer>]

with example data:

>dbmcli -u DAVID,BLUE -ud -d DEMODB -n GENUA

Call the Database Manager CLI, log on to the XUSER program with the user name BORIS and password PINK saved under user key DEFAULT.

To identify the user to be deleted, enter a combination of the database name DEMODB and the computer name GENUA:

>dbmcli -ux <default_user>,<password> -ud -d <database_name> [-n <database_computer>]

with example data:

>dbmcli -ux BORIS,PINK -ud -d DEMODB -n GENUA

Call the Database Manager CLI, log on as the user to be deleted - DAVID - with the password BLUE in the XUSER program.

Enter the user key DAKEY to identify the user to be deleted:

>dbmcli-u <user_name>,<password> -ud -uk <user_key>

with example data:

>dbmcli -u DAVID,BLUE -ud -uk DAKEY

Call the Database Manager CLI, log on to the XUSER program with the user name BORIS and password PINK saved under user key DEFAULT.

Enter the user key DAKEY to identify the user to be deleted:

>dbmcli-ux <default_user>,<password> -ud -uk <user_key>

with example data:

>dbmcli -ux BORIS,PINK -ud -uk DAKEY

More Information

Utilities, XUSER