Auditing capabilities on Azure SQL Database

• vsamantha35

  SSChampion

  Points: 11529

  More actions

  March 21, 2018 at 9:12 pm

  #344111

  Hi Experts,

  We are using 2016 Azure SQL database. Question is related to Auditing capabilities.
  Would like to know what kind of database events can be audited. Can we audit DDL/DML/SELECT operations on Azure SQL Database.
  Do we have anything similar like Server Audit functionality on Azure SQL?
  Looking for pointers of what all things can be audited for a Azure SQL database.

  Please advise.

  Thanks,

  Sam

• SteveHaselschwerdt

  SSC Veteran

  Points: 295

  More actions

  March 22, 2018 at 5:27 am

  #1984243

  I've not personally done this, but according to this article it sounds like you have some control over this in the portal, powershell, and even in SSMS: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing

  Hopefully that steers you in the right direction.