Use this statement to drop a user.

Syntax

DROP USER user-name 

Parameters

Permissions

Must have DBA authority.

Remarks

None.

Side effects

None.

See also

• ALTER LOGIN POLICY statement
• ALTER USER statement
• COMMENT statement
• CREATE LOGIN POLICY statement
• CREATE USER statement
• DROP LOGIN POLICY statement
• Managing login policies overview

Standards and compatibility

Example

The following example drops the user SQLTester from a database.

DROP USER SQLTester;