Subject Re: [firebird-support] How to add and log as different user other than SYSDBA?
Author Helen Borrie
At 06:19 PM 3/09/2005 -0700, you wrote:
>Hi, Helen
> I did like you said. but still doesn't work. I did
>see my password is q12345 in the security.fdb, Does
>Firebird encrypt "q12345" to others when I login? What
>I saw the password of SYSDBA in the security.fdb is
>not the "masterkey" but "n2zpJI3qBh2"

If you can see "q12345" in the security database then your password has not
been correctly stored. What tool did you use to install this user? You
need to use gsec, or a component that calls gsec. A direct INSERT or
UPDATE will not work. Encryption occurs when gsec stores the
password; and both enctyption and decryption occur when the server tries
to authenticate the password.