DROP USER Statement

Removes a user.

Quick Links:

Go to Parameters

Go to Standards

Go to Permissions

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.
SAP Sybase Database product–Not supported by Adaptive Server.

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 December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com