Deletes the specified user.

Syntax

DROP USER {'username'|'username@domain_name'};

Parameters

username

Specifies the user name to be deleted. The username must be enclosed in single quotes.

domain_name

Specifies the domain name that the user is associated with. The username@domain_name must be enclosed in single quotes.

Notes

In a database with tenants, users, and domains, a DBA must complete the following steps to drop a tenant from the database:

  1. DROP USER for every user in the domain.
  2. DROP DOMAIN for every domain defined for the tenant. For more information on dropping a user.
  3. DROP TENANT.

Example

Dropping a user

In this example, an account with DBA privileges drops the username ‘Jasper':

DROP USER 'Jasper' ;

Dropping a user associated with a domain

The example displayed below shows how to drop a user associated with a domain. An user with DBA privileges deletes the user Jasper associated with the domain name mtdomain:

DROP USER 'Jasper@mtdomain';