DROP USER Statement

Removes a user.

Syntax

DROP USER  user-name

Parameters

user-name – name of the user to remove.

Examples

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

Standards

SQL – ISO/ANSI SQL compliant.
Sybase – Not supported by Adaptive Server Enterprise.

Permissions

Requires the MANAGE ANY USER system privilege.

Note: When dropping a user, any objects owned by this user and any permissions granted by this user will be removed.

Parent topic: SQL Statements

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com