Batch Syntax › USER › Examples

Examples

The following examples illustrate the use of the ADD USER command.

Example 1

ADD USER NAME IS DATABASE-ADMINISTRATOR
    PASSWORD IS DBA
    CCID  (DBADMIN, SYSADMIN)
    COMMENT DATABASE ADMINISTRATOR FOR PROJECT'.

The CCDB Administrator has added a new user to be used by the database administrator and has associated this user with both the DBADMIN and SYSADMIN CCIDs.

Example 2

MODIFY USER NAME IS DATABASE-ADMINISTRATOR
    CCID IS NOCCID.
MODIFY USER NAME IS DATABASE-ADMINISTRATOR
    CCID IS DBADMIN.

The CCDB Administrator has modified the user to remove all previous CCID associations and then to associate the user with only the DBADMIN CCID.

Example 3

DISPLAY USER NAME IS DEV*.

This command will display all users in the CCDB whose name matches the "DEV" name-mask.

Example 4

DELETE USER NAME IS DEVUSER  FORCE.

The CCDB Administrator has decided to delete the USER and to force all CLEs associated with the USER to also be deleted.