Hi,

I encrypt data in my application and store data in FB. I then have a Stored Procedure do decrypt the data enabling queries to be run OK. The stored procedure require a KEY that is external to the database.

Regards



Peter Gore

Intel Systems Manager

(ddi) 01277 376433

(swb) 01277 372916

(mob) 07891 911989



________________________________

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Dimitry Sibiryakov
Sent: 16 June 2009 22:44
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Encryption

> While this approach will work, it is far to "naïve" to have real world use.

May be I just read The Daily WTF too much... "Real world" doesn't
seem so perfect.

SY, SD.





__________________________________________________________________________
Martin McColl Ltd, Ashwells Road, Brentwood, Essex CM15 9ST

This e-mail including any attachments is intended only for the addressee
named above and it may contain confidential or privileged information.
If you are not the intended recipient please notify the sender and note
that the contents must not be disclosed to anyone else, no copies can be
taken and all existing copies must be destroyed.
Martin McColl Ltd will not be liable for any error in transmission.
You should carry out your own virus checks before opening any attachments.
Opinions, conclusions and other information in this message
and attachments that do not relate to the official business
of Martin McColl Ltd are neither given nor endorsed by it.


[Non-text portions of this message have been removed]