> And it's actually pretty unhandy, if you need to reconnect to
> the database to perform a certain task under a new role.
>
> Can someone explain why this approach was used in SQL, instead
> of a more simple solution?

Well, ask the SQL committee :-)

Anyway - feel free to write a feature request, as there are currently
several ideas floating around regarding security for Firebird 2.0...


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com