DROP END USER

Purpose

Use DROP END USER to drop an existing end user. Note that you cannot drop an end user if it has an active session.

When a Deep Sec user or role is dropped, the user and the role is removed from the grantee list of existing data grants. If the user or role being dropped is the only grantee of a data grant, the data grant will be dropped when the user or role is dropped.

Prerequisites

You must have the DROP END USER system privilege to execute this command.

Syntax

Description of the illustration drop_end_user.eps

Semantics

IF EXISTS: If you specify IF EXISTS, and the end user exists, the end user is dropped. If the end user does not exist, no error is thrown.

If you do not specify IF EXISTS, and the end user does not exist, an error is thrown. If the end user exists, then it is dropped.

Example

The following SQL statement drops the end user marvin:

DROP END USER marvin;