| Subject | RE: [IBO] Encryption of data |
|---|---|
| Author | Alan McDonald |
| Post date | 2003-02-26T13:11:05Z |
it obviously depends on what encryption method you are going to use
Alan
-----Original Message-----
From: Olafur Gu?mundsson [mailto:og@...]
Sent: Wednesday, 26 February 2003 11:58 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
Yes, that's a good point.
Regards
Olafur
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 26. februar 2003 12:51
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
i think also - you should think about the character set used on the server
fields, just so the encryption matches and that data is not character set
encrypted as well - I only get this feeling from looking at the wat IB/FB
passwords are encrypted and looking at the password field character set on
the security database
Alan
-----Original Message-----
From: Olafur Gu?mundsson [mailto:og@...]
Sent: Wednesday, 26 February 2003 11:05 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
Thank you, this is one way of doing it, I thought where would be a easier
way.
Do you mean that the decryption should be done in the OnCalculateField?
Regards
Olafur
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 26. februar 2003 11:07
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Encryption of data
At 10:53 AM 26/02/2003 +0000, you wrote:
But I assume you will need to do something along these lines: map
calculated fields for each of your encrypted data fields and hide the
data
fields. AFAIK, the encryption routine should take place in the
OnCalculateField event (which needs to refer to the Row object);
duplicate
the decrypted data into non-data-aware fields for editing; provide
parameterised xxxxSQL statements for all DML operations, calling SPs to
perform the ops; and perform the encryption in BeforePost by encrypting
the values from the non-data-aware controls into the params of stored
procedures.
Helen
Yahoo! Groups Sponsor
ADVERTISEMENT
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Alan
-----Original Message-----
From: Olafur Gu?mundsson [mailto:og@...]
Sent: Wednesday, 26 February 2003 11:58 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
Yes, that's a good point.
Regards
Olafur
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 26. februar 2003 12:51
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
i think also - you should think about the character set used on the server
fields, just so the encryption matches and that data is not character set
encrypted as well - I only get this feeling from looking at the wat IB/FB
passwords are encrypted and looking at the password field character set on
the security database
Alan
-----Original Message-----
From: Olafur Gu?mundsson [mailto:og@...]
Sent: Wednesday, 26 February 2003 11:05 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Encryption of data
Thank you, this is one way of doing it, I thought where would be a easier
way.
Do you mean that the decryption should be done in the OnCalculateField?
Regards
Olafur
-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 26. februar 2003 11:07
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Encryption of data
At 10:53 AM 26/02/2003 +0000, you wrote:
>Hi Helen, do you have a suggestion on this?readable
>
>I'm going to implement encryption of my data so that it will not be
>to the sysdba on database level.the
>
>I'm using TIB_Transaction, TIB_Datasource, TIB_Query and a TIB_RichEdit
>control.
>
>I would like to do the encryp. in my app so it will be sent encry. to
>server.the
>
>Where / in what event do I encrypt the data and where do I decrypt back
>data before it will show in the RichEdit control ?From own experience? no. I haven't done it.
>
>Can you help me with that?
But I assume you will need to do something along these lines: map
calculated fields for each of your encrypted data fields and hide the
data
fields. AFAIK, the encryption routine should take place in the
OnCalculateField event (which needs to refer to the Row object);
duplicate
the decrypted data into non-data-aware fields for editing; provide
parameterised xxxxSQL statements for all DML operations, calling SPs to
perform the ops; and perform the encryption in BeforePost by encrypting
the values from the non-data-aware controls into the params of stored
procedures.
Helen
Yahoo! Groups Sponsor
ADVERTISEMENT
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/