Subject Re: [firebird-support] Query regarding Firebird Login
Author Helen Borrie
At 05:22 PM 1/02/2007, you wrote:
>Hi,
>
>Can any one tell me "Is it possible in firebird to modify the userId and
>password after the database is installed."
>
>While installing the database, I specified the user id as = test and
>password as test .
>Now I want to change them to sysdba and masterkey.

Unless there is something you are not telling, you don't have to do
anything. The database SERVER owns the logins and stores them in a
database called security.fdb (or security2.fdb if you are using
v.2). On all platforms the user SYSDBA is already there. On
Windows, the default password is already 'masterke' (only 8
characters of a password are read).

On Linux, the installation script generates a password of 8 random
characters for the SYSDBA. To find out what it is, read the text
file SYSDBA.password in Firebird's root directory. You can change
the password if you like, even to 'masterke'. Use the gsec utility for that.

I guess you know that using 'masterke' (or masterkey) as the SYSDBA
is not a cool idea. Every man and his dog knows it and the SYSDBA
has destructive rights over all databases and their objects.

./heLen