> Firebird Server 1.5.2
> using fbclient.dll
>
> Hello,
>
> if I am trying to log in with an existing username and a correct
> password, but mixing up upper and lower case in the username, I do not
> get an error.
>
> I get access to the database, but with privileges according to user
> "public".
>
> example:
> username = KNAPPSTEIN
> password = password
> successfully logged in with privileges of user "KNAPPSTEIN"
>
> username = knappstein
> password = password
> successfully logged in with privileges of user "PUBLIC"
>

not sure I can believe this... username is case insensitive. You're not
using roles here as well? or using " quotes or something? OR do you have
some environment vairable set?
what OS, what client connection components are you using?

> username = knappsteyn
> password = password
> login denied (ask database admin to setup username and password...)

sure as hell this one is correct - no login possible with a completely
different name which doesn't exist in the security database

>
> Is that supposed to be so?
>
> ciao,
> André
>

Alan