[... large amount of cruft removed by Moderator.
Please TRIM your postings! ...]

C.J. wrote:

>
> My mistake was in assuming that granting a role to a user would
> limit a user on login with just the login of; the path to the
> database, the user name and the user password. Once logged in the
> database server would "understand" 'Bob', has restricted access as
> defined by the role 'mgr'. In fact, Firebird will default the user
> to Public, when the role is ommited during login.
>
> This behaviour is different than what I was expecting, thanks alot
> Helen!
>
> I guess I should buy your book now ;^P
>

This is not necessarily what you would expect in other sql databases.
You have to learn the quirks of each.

regards
ian