-du: Deleting XUSER Entries 

Use

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.

We recommend that you use the XUSER tool directly.

See also: Utilities, XUSER

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

Syntax

-ud

Examples

...

       1.      Calling up the Database Manager CLI, logging on as the user who is to be deleted in the XUSER program (example: user DAVID with password BLUE),
To identify the user who is to be deleted, specify a combination of the database name and computer name (example: database name DEMODB, database computer GENUA).

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

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

 

       2.      Calling the Database Manager CLI, logging on to the XUSER program with the user data stored under the user key DEFAULT (example: user BORIS with password PINK),
To identify the user to be deleted, specify a combination of the database name and computer  name (example: database name DEMODB, database computer GENUA).

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

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

 

       3.      Calling the Database Manager CLI, logging on as the user who is to be deleted in the XUSER program (example: user DAVID with password BLUE),
To identify the user to be deleted, specify the user’s user key (example: DAKEY).

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

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

 

       4.      Calling the Database Manager CLI, logging on to the XUSER program with the user data stored under the user key DEFAULT (example: user BORIS with password PINK),
To identify the user to be deleted, specify the user’s user key (example: DAKEY).

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

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