How to change password SYSDBA (Interbase/Firebird)

Important

In some installations Interbase / Firebird start of the utility gsec is possible only at an input in system on behalf of the exclusive user (for example, root in system Linux) or the user on behalf of whom there is a start of server process Interbase / Firebird. On server systems Windows for use of the utility gsec, usually, you should be a member of group Power User () or other more competent group.

If you are assured, that you have enough privileges, but use gsec comes to an end with messages of type « unavailable database - unable to open database » - probably, the server is not started.

Let's assume you have decided to replace password SYSDBA on i4cur5tr.

1. Pass to the interpreter of the command line and to replace a current directory with that in which there are utilities of the command line.
2. Type the following (on all platforms, except for Windows, the text is sensitive to the register of letters):

gsec-user sysdba-password masterkey

After pressing key Enter, you should observe the invitation of the utility gsec:

GSEC>

3. Type the command:

modify sysdba-pw i4cur5tr

4. Press Enter. New value of the password - i4cur5tr, зашифровывается also is saved, the previous value - masterkey, now is void.
5. For an output from gsec, use the command:

quit

Enjoy!!!
© Ramzaj