DROP USER statement [UltraLite]

Drops a user.

Syntax

DROP USER userid  IDENTIFIED BY password

Parameters

userid
The user ID of the user you are dropping.
password
The password for the user.

Remarks

If you use this statement in a procedure, do not specify the password as a string literal because the definition of the procedure is visible in the SYSPROCEDURE system view. For security purposes, specify the password using a variable that is declared outside of the procedure definition.

Side effects

None.

Example

The following example drops the user SQLTester from a database.

DROP USER SQLTester