Open topic with navigation
DROP USER — remove a database user
name[ IF EXISTS ]
DROP USER statement to remove a user from the database.
If you use
DROP USER to drop a user created with
CREATE USER , 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.
When you drop a user, NuoDB purges all of that user's schema objects from the database.
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 of a user
CREATE USER jonathan PASSWORD 'jonathan'; DROP USER jonathan; DROP USER nosuchuser IF EXISTS; DROP USER nosuchuser;user NOSUCHUSER doesn't exist