Subject Roles and security issue
Author Alan McDonald
Over many years of using a firebird database, users are created, roles are
granted. If you have moved your database several times over this longish
period without first purging roles, you end up with a database with perhaps
many grants of users to roles which are no longer in use. If a new user is
created and coincidentally matches a previous user with an existing grant,
this new user will immediately have these grants.
There appears no tool available to easily reveal or manage these orphaned
grants. I would hazard to guess that many people are unaware that there are
these grants "ready to go" in this moved database. Does anyone consider this
as a security issue, minor as you may regard it?

regards
Alan McDonald