>
>
>Firebird developers....
>
>Are a good feature have record encryption based on user or roles ?
>Or permissions (select, update, delete) on records based on
>users/groups/roles ?
>
>If a feature like this could be implemented will be transparent for the
>client application, the server decrypt the data if the user has enough
>privileges, otherwise crypted (or null) values will be returned, or if the
>user has no select privilegie for that record, the record was not returned
>from the server like if the record was on an uncommited transaction...
>
>Or this is insane ? Too much overhead ? ;-)
>

I think if the server decrypts it, then you are only solving half the
problem. The decryption
should happen in the client software (FB Client).

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus