Re: Encrypt data before inserting into DB
Posted in 1998
Topics: Stored Procedures & SPL, Security, Permissions & Auditing, Java & JDBC Development
If you plan on encrypting the data, don't do it in Javascript or VBScript. You must do this in COM code. To be totally secure, you will need to implement public key cryptography. In VC++, Microsoft has supplied algorithms that do this. If you do a more brute force approach and do a simple encryption, the system administrators will be able to break the code. So, you should follow the suggestion of securing the data in the table and do public key encryption. Good luck. Allen Strand John Kaiser wrote: > If I read your question right, there is a much simpler solution. > > You need to write 2 server side functions. > > One function to take a string and return an encoded string. > Another function to take the encoded string, and return a normal string > > I think there are some ready made ones on the web - look for JavaScript > sites > > norli wrote in message <35BFC268.5C8360C0@asiapac.net>... > >Hi all, > > > >I'm working on an intranet Payroll System. Since salary information are > >confidential, I'd like to have it encrypted before inserting it into the > >database, and decrypted before displaying on the screen. I'm developing > >my apps using Informix 7.22 & SQL Server 6.5 db, using html, javascript > >& vbscript. Is there a way around it? > > > >Thanks in advance! > > > >- norli - > >