Data Encryption

forum.centura.team.developer (1998-2005) & forum.sqlwindows (2000-2005)
steve

Data Encryption

Post by steve » 20 Jan 2005, 12:12

 Posted by:  steve 

Guys,
Is there a SQLBase function that will allow data to be stored in a column in
the database in an encypted format, and also a way to get it back again?

We are looking at putting usernames and passwords into a database, and want
to try to keep it as secure as possible.

cheers

Steve

RainerE
Germany
Posts: 2214
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: Data Encryption

Post by RainerE » 20 Jan 2005, 14:04

 Posted by:  Rainer Ebert 

One simple possibility is to use the functions SalStrCompress() and
SalStrUncompress().
Or implement your own encryption routine.

Rainer

steve

Re: Data Encryption

Post by steve » 20 Jan 2005, 14:59

 Posted by:  steve 

Sorry guys, meant to post in the SQLBase forum.

Still won't say no to any helpful hints though.

Cheers

Gerhard Achrainer

Re: Data Encryption

Post by Gerhard Achrainer » 20 Jan 2005, 17:12

 Posted by:  g.achrainer 

Hi,

if you want it to be as secure as possible, I'd recommend to store
"@encrypt(:strPassword)" in your table and check the passwords using "where
@encrypt(:strPassword) = COLNAME".

Having no "decrypt" function might be an advantage for security...

Regards,

gerhard.

Jim McNamara

Re: Data Encryption

Post by Jim McNamara » 24 Jan 2005, 18:06

 Posted by:  Jim McNamara 

Maybe this will help. There is probably an old posting in forum.sourcecode
that had a bug in it. This version is in production. We are using it for
something similar to what you are doing.

You do not have the required permissions to view the files attached to this post.

Jim McNamara

Re: Data Encryption

Post by Jim McNamara » 24 Jan 2005, 18:16

 Posted by:  Jim McNamara 

P.S. If your database is SQLBase a user name or password cannot start with
a number or contain special characters so use the all upper case letters
character set.

Return to “forum.sqlwindows”

Who is online

Users browsing this forum: [Ccbot] and 0 guests