Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

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