I am working on a legacy ecommerce platform and have noticed a convention when dealing with credit card numbers. C#
cardnumber = "11111111111111111111";
cardnumber = null;
or in sql
update cards set cardnumber = '11111111111111111111' where customerid = @CustomerID
update cards set cardnumber = null where customerid = @CustomerID
I presume the reasoning is to remove it from memory before setting it to null which may not remove the value. But that reasoning would seem to suggest that SQL Server and/or the .NET VM had vulnerabilities in where just setting it to null would not remove the data completely just say that it is available.
- Is my understanding of it correct?
- Does it still need to be performed today?