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

Related reference

CREATE LOGIN POLICY Statement

CREATE USER Statement

DROP LOGIN POLICY Statement

ALTER LOGIN POLICY Statement

GRANT ROLE Statement

GRANT System Privilege Statement

REVOKE System Privilege Statement

REVOKE ROLE Statement

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