DROP USER statement

Description

Removes a user.

Syntax

DROP USER  user-name

Examples

Example 1

The following example drops a user named SQLTester from the database.

DROP USER SQLTester;

Usage

user-name The name of the user.

Side effects

None.

Standards

SQL2003 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.

Permissions

Must have DBA 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