How to read data masking on SQL Server?

Question

Hello Everyone,

We have been enabled C2 Audit on SQL Server 2019 EE and we see the outcome as below details once of update statement query:

UPDATE [CustomerAccount] SET [AccountTypeId] = @p578, [ActiveBit] = @p579, [CrDt] = @p580, [CustomerAccountAaliasName] = @p581, [CustomerAccountCbsName] = @p582,

Is there any ways to understand the raw value of "@p578, @p579,@p580..."

I hope I will get the answer from this question from all you experts here.

Best Regards,

Meakkra

Answer 1

The audit logs generated in C2 auditing mode are primarily designed for security and compliance purposes. They provide a record of actions taken in the database, which can help in identifying who did what and when. While they may contain information about the SQL statement that was executed, including the query text, they typically do not include the parameter values used in those queries.

Note:- The C2 security standard has been superseded by Common Criteria Certification. See the common criteria compliance enabled Server Configuration Option.

Hope this helps