DROP USER

The DROP USER statement removes a user from the database.

Required privilege

ADMIN

Usage with TimesTen Scaleout

This statement is supported with TimesTen Scaleout.

SQL syntax

DROP USER user

Parameters

Parameter Description

user

Name of the user that is being dropped from the database.

Description

Before you can drop a user:

  • The user must exist either internally or externally in the database.

  • You must drop objects that the user owns.

  • When replication is configured, this statement is replicated.

Examples

Drop user terry from the database: 

DROP USER terry;
User dropped.

See also