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

 

Use the DBM option -ud to delete a database user's data and the corresponding XUSER entry in the XUSER program.

For that purpose, log on to the XUSER program either with the data of the database user to be deleted, or with the user data registered under the DEFAULT key.

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

Recommendation Recommendation

We recommend that you use the XUSER tool directly instead of using this DBM option.

End of the recommendation.

Note Note

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

End of the note.

Structure

-ud

Example

Specifying the Database User to be Deleted and the Database Name and Computer Name

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

with example data:

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

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

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

Specifying the User under the DEFAULT Key and the Database Name and Computer Name

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

with example data:

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

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

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

Specifying the Database User to be Deleted and a User Key

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

with example data:

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

To identify the user entry to be deleted, enter the user key DAKEY:

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

Specifying the User under the DEFAULT Key and a User Key

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

with example data:

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

To identify the user entry to be deleted, enter the user key DAKEY:

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

More Information

Utilities, XUSER