Show TOC

DROP USER StatementLocate this document in the navigation structure

Removes a user.

Syntax
DROP USER <user-name>
Parameters

(back to top)

  • user-name name of the user to remove.
Examples

(back to top)

  • Example 1 drops the user SQLTester from the database:
    DROP USER SQLTester
Standards

(back to top)

  • SQL–ISO/ANSI SQL compliant.
  • SAP Database products–Not supported by SAP ASE.
Permissions

(back to top)

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.