LATEST VERSION: 5.x - RELEASE NOTES

Pivotal Greenplum

Download Ask for Help Knowledge Base

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

DROP USER

Removes a database role.

Synopsis

DROP USER [IF EXISTS] name [, ...]

Description

DROP USER is an alias for DROP ROLE. See DROP ROLE for more information.

Parameters

IF EXISTS: Do not throw an error if the role does not exist. A notice is issued in this case.
name: The name of an existing role.

Compatibility

There is no DROP USER statement in the SQL standard. The SQL standard leaves the definition of users to the implementation.

See Also