DROP USER

Syntax

DROP USER external-user-name;

Description

The DROP USER statement drops the External Username associated with a Guardian username. However, the Guardian user information still resides in the metadata.

Parameters

external-user-name: is the External Username to be dropped.

Considerations

The metadata for the system catalog must be 3500 or higher.

Authorization Requirements

To drop an External Username, you must be a security administrator or the Super ID (if Super ID is a part of the Security Administrator’s group or if no Security Administrator’s group exists).

Example Command

The following command drops the External Username:

DROP USER "EMEA\Customer";

The command does not remove the corresponding Guardian user, nor affects the privilege group membership, or any privileges held by that Guardian user.