DROP USER statement

Description

Removes a user.

Syntax

DROP USER  user-name

Examples

Example 1

This example drops a user named SQLTester from the database.

DROP USER SQLTester;

Usage

user-name The name of the user.

Side effects

None

Standards

SQL Vendor extension to ISO/ANSI SQL grammar.

Sybase Not supported by Adaptive Server Enterprise.

Permissions

Must have DBA or USER ADMIN authority.

See also

ALTER LOGIN POLICY statement

CREATE USER statement

CREATE LOGIN POLICY statement

DROP LOGIN POLICY statement

GRANT statement

“Managing login policies overview” in SQL Anywhere Server – Database Administration > Configuring Your Database > Managing user IDs, authorities, and permissions