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

15 comments:

Unknown 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?

Anonymous 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.

Unknown 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.

Anna Schafer 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

Anna Schafer 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.

Anna Schafer 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

Anna Schafer 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

Anna Schafer said...

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

Anna Schafer said...

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

Owais Khan 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

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