Subject Re: [Firebird-general] pro&contra
Author Aage Johansen
Ann W. Harrison wrote:
> Anderson Farias wrote:
>>> I think that in Sybase (and probably in IB) you can encrypt specific
>>> columns of a table, and users without priviledge to decrypt will just
>>> see "noise" in those particular columns.
>> Yes, IB has this ability. And I agree with Steve Summers when he says that
>> IB would be best move since changing from FB to IB would be probably a lot
>> less work (than to any other DB).
> How does IB handle keys in that case? And indexes?

I expect performance to be lousy for some/many kinds of queries as
indexes will be less useful.
It would be interesting to see some reports from users who utilize
column encryption. I asked once about encryption on an IB newsgroup
some weeks ago - there were no takers.

Aage J.