Firebird SQL SECURITY DEFINER routines and PUBLIC table grants — privilege elevation at the routine–table boundary
Integration boundary Firebird 4.0 introduced SQL SECURITY DEFINER for stored procedures and triggers, allowing routines to execute with the creator's privileges rather than the caller's. At the same time, the implicit PUBLIC role grants any privileges assigned to it to every connected user. The interoperability question is how these two mechanisms interact w
firebird