DROP ROLE

From InterBase
Jump to: navigation, search

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 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;

See Also

Advance To: