DROP USER Statement

Removes a user.

Syntax

DROP USER  user-name

Examples

Example 1 – Drop the user SQLTester from the database:
```
DROP USER SQLTester;
```

Usage

user-name—Name of the user to remove.

See SQL Anywhere Server - Database Administration > Configuring your database > Managing user IDs, authorities, and permissions > Managing login policies.

Note: This reference points to SQL Anywhere documentation.

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

CREATE LOGIN POLICY Statement

CREATE USER Statement

DROP LOGIN POLICY Statement

GRANT Statement

ALTER LOGIN POLICY Statement

Created August 28, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com