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
We recommend that you use the XUSER tool directly.
Note
Unlike user names and passwords, the Database Manager treats user keys as case sensitive.
-ud
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
Utilities, XUSER