3 results found

1. Firebird 3 Database Encryption Support

   In Firebird 3.0 release there is an option to encrypt the whole database (http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-encryption.html).
   For the encryption of the database you need a plugin (like this one that is working with AES128 from https://www.ibphoenix.com/products/software/encryptionplugin).
   To open an encrypted database you just have to send the encryption key via a callback function "setDBCryptCallback" to the Firebird server.
   My idea is if it's possible that the IBDAC component would be upgraded with the functionality to automaticly pass a setted "encryption_password" parameter (maybe there will be a need to have also a paramter for setting the Encryption library).
   If you want to connect to an encrypted database with the latest version of IBDAC (5.7.25 08-Sep-16) you get a message "Encryption key is not set" at trying to set TIBCConnection.Connected to true.

   The whole point of the database encryption is that you gain security. If someone moves an encrypted database to an other location then they cannot access it until they decrypt it with your encryption key.
   The idea is that you have to pass the encrypton key remotely. A big security leak would be to have a encrypted database and the encryption key on the same location (server).

   In Firebird 3.0 release there is an option to encrypt the whole database (http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-security-encryption.html).
   For the encryption of the database you need a plugin (like this one that is working with AES128 from https://www.ibphoenix.com/products/software/encryptionplugin).
   To open an encrypted database you just have to send the encryption key via a callback function "setDBCryptCallback" to the Firebird server.
   My idea is if it's possible that the IBDAC component would be upgraded with the functionality to automaticly pass a setted "encryption_password" parameter (maybe there will be a need to have also a paramter for setting the Encryption library).
   If you… more

   102 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   declined  ·  2 comments  ·  InterBase/Firebird  ·  Delete…  ·  Admin →

2. para fazer testes e simulações

   fazer testes e simulações de banco de dados na faculdade e em case.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  InterBase/Firebird  ·  Delete…  ·  Admin →
   declined  ·  AdminDevart (_, Devart) responded

   Please write suggestions in English, in order to avoid translation mistakes.

3. Transaction Customized = more flexibility to the programmer

   In FIBPlus we can make transactions customized

   using keywords as:

   read, write, wait, no wait, etc... all in custom menu for Transaction object

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  InterBase/Firebird  ·  Delete…  ·  Admin →
   declined  ·  AdminDevart (_, Devart) responded

   Such functionality is implemented in IBDAC.

   Here is a code example:

   IBCTransaction.IsolationLevel := iblCustom;
   IBCTransaction.Params.Clear;
   IBCTransaction.Params.Add(‘wait’);
   IBCTransaction.Params.Add(‘read_committed’);
   IBCTransaction.Params.Add(‘rec_version’);

   The same can be done in the desing-time using the transaction component’s designer form.