On Tuesday 14 October 2008 12:16, said bounderra wrote:

> I think that you did not understand what i mean ..
> So !!
> The password about what you talk is saved in the database security of the
> server (security.fdb ) but what i mean is that the password for encrypting
> a database will be saved in my database it self for exemple : I create a
> database named "exemple.fdb" and I protect it with a password : "qwerty" so
> when i distribute or give it to another user (freind ) .. it can not open
> it even if he knows the SYSDBA password because the database request
> another password : "qwerty" It Means 2 level of protection : Database
> password it self and SYSDBA password.

There is such feature in firebird - it's called database encryption. You
should write crypt function (symmetric), and provide a key for encryption /
decryption by block in DPB. But there is no big use in such approach - for
open source database everyone can easily build an engine which will simply
type password passed from application. Therefore (as far as I know) this was
not tested last time.