Protect firebird embedded file

Question

is there any thumb of rules or step-by-step guide how to re-build firebird database in win xp? I mean to change SYSDBA's password, not with gsec command.. :-D regard

Answer 1

Changing the password in the firebird embedded server enviroment doesn't make any difference as the embedded server doesn't authenticate users, it only uses the username. So you can always use the embedded with full privileges using username SYSDBA and random password.

Anyway, there is SQL user management commands available in Firebird 2.5 which allow you to work with users without using gsec.

Answer 2

As for today the only way to protect FB embedded database file is to put it onto encrypted disk. Use TrueCrypt or any other available encryption utility.