A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Removes a database role.
DROP USER [IF EXISTS] name [, ...]
DROP USER is an obsolete command, though still accepted for backwards compatibility. Groups (and users) have been superseded by the more general concept of roles. See DROP ROLE for more information.
- IF EXISTS
- Do not throw an error if the role does not exist. A notice is issued in this case.
- The name of an existing role.
There is no DROP USER statement in the SQL standard. The SQL standard leaves the definition of users to the implementation.