Sunday, June 17, 2012

How to securely mask credit card numbers

Often banks need to send large amount of data to outside vendors to perform data analysis. It is safer to mask sensitive data items such as credit card numbers, social security numbers, etc. The following is one approach to securely mask credit card numbers.

1. Generate a random number for each credit card number.
2. Generate a rank for each random number using row_number().
3. Generate the masked credit card number based on the rank.
Step 1. create table tbl_card_w_rand_num as select card_number, dbms_random.random() rnd from tbl_cards;
Step 2. Generate the masked credit card numbers based on the rank of random numbers. Keep this table in a safe place.

create table tbl_masked_card_num as with tbl as(
select a.*, row_number() over(order by rnd) rnk from tbl_card_w_rand_num a)
select a.*, 'A'||lpad( rnk,15,'0') masked_card_num from tbl a;
Step 3. Create data using masked_card_num

16 comments:

kierran campbell said...

I've been thinking of following those reminders in credit card merchant account sc but what I'm worried is that the bank will be confused with my credit records. Is this even possible?

nancy nam said...

They also have a high level encryption for airwave transmission of financials that run through the banking VPN. So a licensed money lender will setup a secured connection for client transactions.

opu shaon said...

Thankful conversation you did here. Ha it is very safe to mask sensitive data items such as credit card numbers and etc. I hope that here provided allocation will surely be handy for everyone. Thanks once again. :)
click here

albina N muro said...

Information on credit cards, secondary cards and store cards. ... Credit cards. Buying on ReliaCard Login. Credit cards are easy to get and easy to use.

Jodi W. Brown said...

. It is safer to mask sensitive data items such as credit card numbers, social security numbers, etc. The following is one approach to securely mask credit card numbers.JCPenney Credit Card Login

Jodi W. Brown said...

The following is one approach to securely mask credit card numbers.Shell Credit Card

albina N muro said...

According to a new report on debit and Slate Credit Card abroad, spending on debit cards is worse than spending on credit cards.

Jodi W. Brown said...

Credit cards are alright for as long as you properly manage your finances. It becomes dangerous, just like any other thing, when used carelessly. Brooks Brothers Credit Card

jowdjbrown said...

Generate the masked credit card numbers based on the rank of random numbers. Keep this table in a safe place.merchant services online

Elizabeth J. Neal said...
This comment has been removed by a blog administrator.
albina N muro said...

credit card numbers, social security numbers, etc. The following is one approach to securely mask credit card numbers. Credit Restoration

jowdjbrown said...

create table tbl_card_w_rand_num as select card_number, dbms_random.random() rnd from tbl_cards;http://bestpaidsurveyssites.net

jowdjbrown said...

credit card numbers, social security numbers, etc. The following is one approach to securely mask credit card numbers. merchant account provider

Aron_ Seo said...

CommBank has 9 credit cards including low rate credit cards, low annual fee credit cards and reward credit cards. Apply now and get a 60 second response. credit cards

Priya R said...

Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
SAS Training in Chennai | SAS Course in Chennai

Adiba Alam said...

A Business Card Holder is quintessential for a person from varying backgrounds. It positively is your character which spells intensive polished methodology.Business Credit Cards