dbTalk Databases Forums  

Encryption of sensitive data fields in D3

comp.databases.pick comp.databases.pick


Discuss Encryption of sensitive data fields in D3 in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rixx2112@yahoo.com
 
Posts: n/a

Default Encryption of sensitive data fields in D3 - 02-21-2007 , 04:58 PM






I'm only aware of an in built User Exit code for encryption/decryption
of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.


Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX


Reply With Quote
  #2  
Old   
Ross Ferris
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-21-2007 , 05:10 PM






On Feb 22, 9:58 am, rixx2... (AT) yahoo (DOT) com wrote:


Richard,

I doubt that the one-way encryption offered within D3 is anywhere near
your PCI compliance requirements. I would imagine that what you would
need to do is write the sensitive information out as a simple text
file to AIX filespace, run an encryption process over that, read data
back in (probably using the BIN: driver - I'd then convert to hex to
ensure this could be saved as a single-valued "attribute")

Reverse the sequence/processing to get your original data. I'm sure
this is something that GlenB will have experience in doing, and he
would be able to add more detail

HTH



Reply With Quote
  #3  
Old   
Dale
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-21-2007 , 05:39 PM



On Feb 21, 2:58 pm, rixx2... (AT) yahoo (DOT) com wrote:
Quote:
I'm only aware of an in built User Exit code for encryption/decryption
of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.

Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX
I have no idea if the user-exit 009d is PCI compliant, but it does
offer a simple way of encrypting and decrypting strings.

usage: coded.string = ICONV( seed:am:string, 'u009d' )
uncoded.string = OCONV( seed:am:string, 'u009d' )


Regards,

Dale



Reply With Quote
  #4  
Old   
Mark Brown
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-21-2007 , 06:40 PM



I wrote the U9D user exit and it works pretty well.

What makes it PCI compliant (or close) is the length and uniqueness of the
seed. They like 128bit (14 bypte) keys. We use this user exit and a vb
function I wrote that does the same thing to encrypt/decrypt our credit card
transactions. The longer the seed the better.

It is smart enough to not create segment marks in the middle of your string,
but for speed, it's not much smarter than that.


Mark Brown

"Dale" <dale_benedict (AT) flightcraft (DOT) ca> wrote

Quote:
On Feb 21, 2:58 pm, rixx2... (AT) yahoo (DOT) com wrote:
I'm only aware of an in built User Exit code for encryption/decryption
of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.

Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX

I have no idea if the user-exit 009d is PCI compliant, but it does
offer a simple way of encrypting and decrypting strings.

usage: coded.string = ICONV( seed:am:string, 'u009d' )
uncoded.string = OCONV( seed:am:string, 'u009d' )


Regards,

Dale




Reply With Quote
  #5  
Old   
Joe
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-21-2007 , 07:06 PM



rixx2112 (AT) yahoo (DOT) com wrote in news:1172098699.464731.196670
@s48g2000cws.googlegroups.com:

Quote:
I'm only aware of an in built User Exit code for encryption/decryption
of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.


Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX
Is OpenSSL available on the box? If so, you might consider using it for
encryption. IIRC, there are options to use only ascii characters for
encryption so you can store an encrypted string in an attribute or a
value. Very handy in the mv world.

Regards,
Joe


Reply With Quote
  #6  
Old   
GVP
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-21-2007 , 07:28 PM



What for need encription?
- For saving encripted data?
- For data transfer between PC-server or server-server?

What connection You are use?

Regards,
Grigory


Reply With Quote
  #7  
Old   
OldSchool
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-22-2007 , 09:39 AM



On Feb 21, 8:28 pm, "GVP" <g... (AT) infotools (DOT) ru> wrote:
Quote:
What for need encription?
- For saving encripted data?
- For data transfer between PC-server or server-server?

What connection You are use?

Regards,
Grigory
Basically, several credit card companies have developed standards and
practices regarding the processing card information, including not
storing the card # in human readable form......

https://www.pcisecuritystandards.org/



Reply With Quote
  #8  
Old   
Joe
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-23-2007 , 06:48 AM



"Glen B" <no$pamwebmaster@no$pamforallspec.com> wrote in
news:KpmdnYdrXIggV0DYnZ2dnUVZ_vmdnZ2d (AT) giganews (DOT) com:

Quote:
If the defacers haven't gotten to it yet:

http://www.picksource.com/modules.ph...article&sid=97
Gee, that seems familiar...

Regards,
Joe


Quote:
I'm this -> <- close to dropping PickSource due to all the really
pathetic
defacing it has been getting. I guess ignorant hackers have to start
somewhere easy, so they decide to hit PS. I can't just "fix" the
problem, without losing most of the content and features. What sucks
is, when the site gets defaced, the first few articles get toasted.
I'm not going to bother with restoring them either. It seems the only
interest PS gets is from bored teens that just happen to find a
program that does something annoying and destructive to PHP Nuke
systems.

Glen


rixx2112 (AT) yahoo (DOT) com> wrote in message
news:1172098699.464731.196670 (AT) s48g2000cws (DOT) googlegroups.com...
I'm only aware of an in built User Exit code for
encryption/decryption of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.


Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX





Reply With Quote
  #9  
Old   
Joe
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-24-2007 , 02:40 PM



"Glen B" <no$pamwebmaster@no$pamforallspec.com> wrote in
news:Ao6dndvt9KuXvkLYnZ2dnUVZ_oudnZ2d (AT) giganews (DOT) com:

Quote:
"Joe" <dinner (AT) six (DOT) net> wrote in message
news:Xns98E04F7471DF3nospamforme (AT) 216 (DOT) 77.188.18...
"Glen B" <no$pamwebmaster@no$pamforallspec.com> wrote in
news:KpmdnYdrXIggV0DYnZ2dnUVZ_vmdnZ2d (AT) giganews (DOT) com:


If the defacers haven't gotten to it yet:

http://www.picksource.com/modules.ph...article&sid=97

Gee, that seems familiar...

Regards,
Joe



Yup, it's been around for a few years. When I wrote the article,
things
were a bit more slack. Visa is much more strict on card data security
and ecryption now. Total Computing started using the same OpenSSL
shell process to encrypt/decrypt card data in their CC processing
software, so it's still a noteworthy option/method for encrypting and
storing pieces of data in MV.

Glen
That pretty much sums up why I suggested OpenSSL to the OP the day
before your post.

Regards,
Joe


Reply With Quote
  #10  
Old   
Frank Winans
 
Posts: n/a

Default Re: Encryption of sensitive data fields in D3 - 02-26-2007 , 12:10 PM



<rixx2112 (AT) yahoo (DOT) com> wrote
Quote:
I'm only aware of an in built User Exit code for encryption/decryption
of data using Basic under D3.
Does anyone know the strength of this method, and can anyone tell me
if it is PCI (Payment Card Industry)compliant?

The reason I'm asking is that I need is a method to encrypt fields
that would conform to PCI compliance.
If the user-exit is a no-go, I'll need to find another method that
will encrypt data fields.


Cheers,
Richard M.

P.S. This is D3 running on ver 7.4.2.RS on AIX
Note that for some narrowly limited applications it makes more sense
to discard the sensitive data and only retain a 4 byte {8bytes ascii nybbles}
checksum for use in future compares. Or only store the full data in a few
extraordinary offline copies; then you don't have to be so diligent protecting
the numerous overnight backup tapes.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.