Security Basics mailing list archives
RE: Database Encryption and PCI issue.
From: Craig Wright <Craig.Wright () bdo com au>
Date: Wed, 13 Feb 2008 10:32:55 +1100
The DBMS_OBFUSCATION_TOOLKIT package only supports MD5 hashing. No SHA1. The DBMS_CRYPTO package supports MD5, SHA-1, MD4, hashing and also HMAC_MD5, HMAC_SH1 keyed hashing algorithms. The issues is Oracle 9i. It supports MD5 and NO more. So no SHA1 in Oracle 9i. Upgrade to 10g and you get the added crypto package (DBMS_CRYPTO). Also with 9i, there is no padding, only CBC mode and support for RAW, VARCHAR2 database types (i.e. no CLOB, BLOB). Regards, Craig Wright (GSE-Compliance) Craig Wright Manager of Information Systems Direct : +61 2 9286 5497 Craig.Wright () bdo com au +61 417 683 914 BDO Kendalls (NSW) Level 19, 2 Market Street Sydney NSW 2000 GPO BOX 2551 Sydney NSW 2001 Fax +61 2 9993 9497 http://www.bdo.com.au/ Liability limited by a scheme approved under Professional Standards Legislation in respect of matters arising within those States and Territories of Australia where such legislation exists. The information in this email and any attachments is confidential. If you are not the named addressee you must not read, print, copy, distribute, or use in any way this transmission or any information it contains. If you have received this message in error, please notify the sender by return email, destroy all copies and delete it from your system. Any views expressed in this message are those of the individual sender and not necessarily endorsed by BDO Kendalls. You may not rely on this message as advice unless subsequently confirmed by fax or letter signed by a Partner or Director of BDO Kendalls. It is your responsibility to scan this communication and any files attached for computer viruses and other defects. BDO Kendalls does not accept liability for any loss or damage however caused which may result from this communication or any files attached. A full version of the BDO Kendalls disclaimer, and our Privacy statement, can be found on the BDO Kendalls website at http://www.bdo.com.au/ or by emailing mailto:administrator () bdo com au. BDO Kendalls is a national association of separate partnerships and entities. -----Original Message----- From: listbounce () securityfocus com [mailto:listbounce () securityfocus com] On Behalf Of ????? ???????? Sent: Wednesday, 13 February 2008 8:22 AM To: Mohamed Farid Cc: security-basics () securityfocus com Subject: Re: Database Encryption and PCI issue. Hello, Mohamed Farid! What is problem to use hash value (e.g. SHA1 ) of PIN as PK?
Dear All : We are in our way to have a PCI DSS complaint - and we are facing a challenge to have encryption with our Database Systems. The problem is that the Application we are using is using the PIN as a primary key in the DB tables - and this will make it very hard to encrypt the PIN columns ... Anyway - we are using Oracle 9i and the server is connected to HP SAN. Can anyone advise us: what are the systems we can go after to solve this? Is there any technique or 3rd party applications can help us to overcome this? M Farid
-- Тарас Иващенко (Taras Ivashchenko) ---- "Software is like sex: it's better when it's free." - Linus Torvalds
Current thread:
- Database Encryption and PCI issue. m.farid.shawara (Feb 12)
- Re: Database Encryption and PCI issue. Ansgar -59cobalt- Wiechers (Feb 12)
- <Possible follow-ups>
- Database Encryption and PCI issue. Mohamed Farid (Feb 12)
- Re: Database Encryption and PCI issue. Taras Ivashchenko (Feb 12)
- RE: Database Encryption and PCI issue. m.farid.shawara (Feb 13)
- RE: Database Encryption and PCI issue. Craig Wright (Feb 13)
- RE: Database Encryption and PCI issue. Craig Wright (Feb 12)
- Re: Database Encryption and PCI issue. Taras Ivashchenko (Feb 12)
- Re: Database Encryption and PCI issue. amatachick (Feb 13)