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

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