How to read data masking on SQL Server?

Theang Meakkra 0 Reputation points
2023-11-01T06:25:56.7966667+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sreeju Nair 12,026 Reputation points
    2023-11-01T14:01:43.0233333+00:00

    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

    0 comments No comments