Microsoft Azure - SQL Auditing & dynamic data masking

To look into my previous posts on Microsoft Azure.

Azure - SQL Auditing


We can enable SQL Auditing on Azure portal in Database level as well as in Server level.

Before enabling SQL Auditing, we need to create Storage for Audit logs.
Click on STORAGE and try like as shown in below images:










To enable SQL Auditing on Azure portal in Server level:
SQL DATABASES - > click on SERVERS - > click on server name - > AUDITING & SECURITY






To enable SQL Auditing on Azure portal in Database level:
SQL DATABASES - > click on DATABASES - > click on database name - > AUDITING & SECURITY

We can also Inherit auditing settings from server as shown in below image:




Azure - Dynamic data masking

To enable data masking on Azure portal :
SQL DATABASES - > click on DATABASES - > click on database name - > AUDITING & SECURITY - > dynamic data masking



then click on "+" symbol in the bottom ADD MASK to configure dynamic data masking rule on column of a table.

Say for example I have created data masking rule on column CreditCardNumber





Microsoft sites on Dynamic data masking:

Microsoft sites on Azure SQL Auditing:

No comments: