10.3 Drop End User

Use the DROP END USER command to remove an existing local end user from the database.

Required privilege

The DROP END USER system privilege.

Syntax

DROP END USER [ IF EXISTS ] end_user;

Parameters

Parameter Description

end_user

The name of the end user to be dropped.

Usage notes and restrictions

  • When IF EXISTS is specified:
    • If the end user does not exist, the statement is a no-op. No error is raised.
    • If the end user exists, it is dropped.
  • When IF EXISTS is omitted:
    • If the end user does not exist, an error is raised.
    • If the end user exists, it is dropped.
  • You cannot drop an end user who has an active session.

For syntax diagrams and additional details, see DROP END USER in Oracle AI Database SQL Language Reference.

Example 10-3 Drop end user

Drop an end user, Emma.

DROP END USER emma;