DROP USER

DROP USER — remove a database user

Syntax

DROP USER name [ IF EXISTS ]

Description

Use the DROP USER statement to remove a user from the database.

If you use DROP USER to drop a user created with CREATE USER username EXTERNAL, the user will be dropped as an active NuoDB database user, but this will have no effect on the user’s entry in the external LDAP server.

Parameters

IF EXISTS

If the user does not exist and you specify IF EXISTS, NuoDB does not generate an error. Otherwise, if the user does not exist, an error is generated.

name

Name of a user

Example

CREATE USER jonathan PASSWORD 'jonathan';
DROP USER jonathan;

DROP USER nosuchuser IF EXISTS;
DROP USER nosuchuser;
 user NOSUCHUSER doesn't exist