DROP ROLE
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes a role from a database. Available in gpre
, DSQL, and isql
.
DROP ROLE <rolename>;
Important:
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
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.Argument | Description |
---|---|
<rolename> |
Name of an existing role |
Description: 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;