From: "Helen Borrie"

> I think your mistake is in assuming that roles form something like
> user groups. If so, you're not the first. :-)
>
> A simple way to think about the login is:
>
> -- with the username and password the user gets authenticated on the
> server but has no privileges in the database.
> -- when you add the role, you add all the necessary privileges in the
> database.

This is probably the best and easiest-to-understand explanation
of Firebird roles I've ever read :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com