Hi Mitchell

We use data encryption for the wages tables. We have encrypt and decrypt
functions in Delphi and use these in GetText and SetText for data aware
controls.
Also, during development only, we have a decrypt udf so that decrypted views
of the tables can be created for testing and debugging the system.
The encryption creates varchar data which only includes printable
characters.

Regards
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of Mitchell Peek
> Sent: 03 January 2006 22:10
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] data encryption
>
> I proposed this question as a reply to an old thread, throught it might
> have been lost due to the age of the thread, so decided to re-intorduce
> it in its own. Sorry for the redundancy...
>
> someone suggested:
>
> >You may need to store things like credit card numbers or passwords in
> >the database. DBAs have full access to the database, and may need it,
> >but you don't want them to know this information. If you need to get
> >the information back out, then use encryption (blowfish etc) and store
> >the encrypted data only.
> >
>
>
> Any suggestions on the best means of implementing encryption (any, not
> necessarily blowfish) of this sort? UDF? trigger? etc? How does one go
> about implementing such a thing and making this workable?
>
> Thanks,
> Mitchell Peek
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>