You might consider using SQL GRANT/REVOKE on the column that contains
the CC number. You could password the database, and make that column
inaccessible without the password. You can do this by granting public
access to everything, then revoking access to that particular column.
This might be a bit heavy duty for your needs, but it would work.
Albert
Dick Fey wrote:
Not a huge deal, but our credit card processor (our bank) is
requesting that we prove that we have a secure way to keep customers
credit card info.
Because we routinely do business with the same customers, we save the
credit card data.
Our server does have an always on internet connection, properly
firewalled.
None of our data is accessable from the internet.
