System and method for at-source masking of sensitive data

The system for masking data at-source comprising:

• an input/output interface for receiving a response output comprising a sensitive data, based on a user request, from a table of a production database,
• one or more hardware processors;
• a memory in communication with the one or more hardware processors, wherein the one or more hardware processors are configured to execute programmed instructions stored in the memory, to:
• identify a column with at least one unique identifier, based on the response output, for masking of the sensitive data in the response output;
• create at least one temporary table comprising three or more columns, wherein at least one column of the temporary table comprising the sensitive data of the production database;
• mask the at least one column of the temporary table with sensitive data using predefined masking rules;
• insert the masked column of the temporary table in the production database;
• and
• update the production database with masked data of the temporary column, wherein the temporary table comprising the identified unique column, original data of sensitive column and masked data of sensitive column for at source data masking.

In yet another embodiment, a non-transitory computer readable medium storing one or more instructions which when executed by one or more processors on a system cause the one or more processors to perform the method comprising:

• receiving, via one or more hardware processors, a response output comprising a sensitive data, based on a user request, from a table of a production database;
• identifying, via the one or more hardware processors, a column with at least one unique identifier, based on the response output, for masking of sensitive data in the response output;
• creating, via the one or more hardware processors, at least one temporary table comprising three or more columns by executing a data definition language (DDL) operation, wherein at least one column of the temporary table comprising the sensitive data of the production database;
• masking, via the one or more hardware processors, the sensitive data of the at least one column of the temporary table using predefined masking rules;
• inserting, via the one or more hardware processors, the at least one masked column of the temporary table in the production database;
• and
• updating, via the one or more hardware processors, the production database with masked sensitive data of the at least one column of the temporary column, wherein the temporary table comprising the identified column with at least one unique identifier, original data of the sensitive column and masked data of sensitive column for at-source data masking.