FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 SQL PrivilegesStatements for Granting Privileges 

DROP ROLE

Drops a role

Available in

DSQL, ESQL

Syntax
DROP ROLE rolename

The statement DROP ROLE deletes an existing role.It takes a single argument, the name of the role.Once the role is deleted, the entire set of privileges is revoked from all users and objects that were granted the role.

Who Can Drop a Role

The DROP ROLE statement can be executed by:

  • Administrators

  • The owner of the role

  • Users with the DROP ANY ROLE privilege

docnext count = 1

DROP ROLE Examples

Deleting the role SELLERS
DROP ROLE SELLERS;
See also

[fblangref50-security-role-create], GRANT, REVOKE