Firebird Documentation IndexFirebird 3.0.2 Release NotesSecurity → Restriction on DROP ROLE (v.3.0.1)
Firebird Home Firebird Home Prev: Pseudo-Tables with List of UsersFirebird Documentation IndexUp: SecurityNext: Data Definition Language (DDL)

Restriction on DROP ROLE (v.3.0.1)

CORE-5248.

Prior to Firebird 3.0.1, any user could drop a role. This is a bug which has been fixed in sub-release 3.0.1. Now, only the user who created the role and one who has been granted the role WITH ADMIN OPTION can drop it.

Important

To obtain the proper behavior in old databases, roles should be recreated!

Prev: Pseudo-Tables with List of UsersFirebird Documentation IndexUp: SecurityNext: Data Definition Language (DDL)
Firebird Documentation IndexFirebird 3.0.2 Release NotesSecurity → Restriction on DROP ROLE (v.3.0.1)