> -----Ursprüngliche Nachricht-----
> Von: Gerson Machado - Yahoo [mailto:gersonamach@...]
> Gesendet: Dienstag, 21. Dezember 2004 13:43
> An: firebird-support@yahoogroups.com
> Betreff: RES: [firebird-support] Re: Encryption in firebird - Help
>
>
>
> Adam,
>
> Perhaps what Carlos need is like me....
>
> I need (to protect my information) to encrypt and decrypt my
> data when necessary, but I want to do this, in Firebird, not
> in Delphi or other language, native inside Firebird.

And how do you read your data if the database encrypts all data for you? Or are you afraid of someone getting your database file? Why would you want to encrypt/decrypt table data?

> Other thing, I need protect the relationship between all
> tables... like if I have a field in table A with information
> in table B I need to break (or encrypt) this relationship.

That's nonsense. I've never heard of encrypted relationsships. If there is a relationship, it is visible to the database and anyone else with access to both tables. If there is no relationship visible, it does not exist. If you want to deny access to a relationship for some users, simply deny access on one or all tables, or use views if the relationship is the only thing you want to hide. For example: create a view from Table B without the foreign key thats linked to table A. Then no one without access to the underlying table will be able to do a join between both tables (excerpt a cross join).

Regards, Alexander Gräf