Drops a user.
DROP USER userid IDENTIFIED BY password
The user ID of the user you are dropping.
The password for the user.
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.
The following example drops the user SQLTester from a database.
DROP USER SQLTester