Deletes a role from a database. Available in
gpre, DSQL, and
DROP ROLE <rolename>;
- Important: In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
isql, the semicolon is a terminating symbol for the statement, so it must be included.
Name of an existing role
DROP ROLE deletes a role that was previously created using
CREATE ROLE. Any privileges that users acquired or granted through their membership in the role are revoked.
A role can be dropped by its creator, the
SYSDBA user, or any user with superuser privileges.
Example: The following
isql statement deletes a role from its database:
DROP ROLE administrator;