> -----Ursprüngliche Nachricht-----
> Von: carlos_arguilar [mailto:carlos_arguilar@...]
> Gesendet: Dienstag, 21. Dezember 2004 10:25
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] Encryption in firebird - Help
>
>
>
> Hello!
> I have a table in my database that has a field that need encryption.
> I have wrote a UDF, however, it don't work very well on firebird.
> Anyone know a routine be able such a thing.
> Please, help me.
> Regards,
> Carlos Arguilar
>

If you need to do encryption, use SHA1 or MD5 for example, or if you need to decrypt the data, use DES or BlowFish. Anyway, encrpyt it in your application and store the ciphre in a BLOB or CHAR (xy) CHARACTER SET OCTETS.

If you want to hide some fields of your database from certain users, simply use a view without the field and deny access for these users to the underlying data table. The table will still be editable, and users with right to access the underlying table can update and retrieve this field.

Regards, Alex