DROP USER Statement

Removes a user.

Syntax

DROP USER  user-name

Examples

Usage

 user-name—Name of the user to remove.

See SQL Anywhere 11.0.1 > SQL Anywhere Server – Database Administration > Configuring Your Database > Managing user IDs, authorities, and permissions > Managing login policies overview.

Standards

  • SQL—ISO/ANSI SQL compliant.

  • Sybase—Not supported by Adaptive Server Enterprise.

Permissions

Must have DBA or USER ADMIN authority.

Parent topic: SQL Statements
Related reference
ALTER LOGIN POLICY Statement
CREATE LOGIN POLICY Statement
CREATE USER Statement
DROP LOGIN POLICY Statement
GRANT Statement