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:
