Secure Connection

[TwixII]

Hi,

we're developing with Delphi 2007/DOA accessing data on a remote Oracle Server (10G). What would be the best/easiest way to make this connection secure. Do we have to make changes on the db as well?

Thanks for any help/ideas.

 

[Marco Kalter]

For data encryption I would suggest that you use the standard Oracle functionality. It is transparent to the application. See also:

http://download.oracle.com/docs/cd/B28359_01/network.111/b28530/asoconfg.htm

 

[ldsandon]

Isn't Advanced Security a database options to be licensed separately? A cheaper solution may be to configure IPSec between client and server, although it does not protect end-to-end (Data get encrypted/decrypted between network endpoints, but between the network and application/database they are not). IPSec provides machine authentication, but not users - but user authentication can still be performed ad the database level.