Subject System predefined roles
Author Claudio Valderrama C.
Hello, all.
When IB5 was created, roles were added. Apologies if I hurt someone here,
but I can't understand why, despite other system tables, nobody thought on
including a rdb$system_flag field in rdb$roles. Even rdb$functions has such
system flag "just in case" for possible enhancement. So, adding this field
means an ODS upgrade.
If we have some predefined, system roles, we could allow some "features" or
"privileges" to be added to non-SYSDBA users without users having to fiddle
with system tables directly. Almost any RDBMS I know has some predefined
roles or user categories.
Would some predefined roles fit into FB architecture nicely?

Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente