CODEWITHSUNDEEP
sql-serverazureazure-sql-database
Jason Steele
Jason Steele

Reputation: 1606

Auditing SQL Azure

As I understand it, the Security eventlog cannot be copied to WAD Diagnostics storage and SQL Server auditing is not available for SQL Azure.

What solutions have you come up with for auditing access to a SQL Azure database?

At a minimum it should be login, IP and when; but preferably the actual SQL executed as well.

Upvotes: 1

Views: 1080

Answers (1)

ntziolis
ntziolis

Reputation: 10231

Recently the Azure SQL team introduced some new system views that expose at least the login infos.

Announcing: New System Views for Windows Azure SQL Database: http://azure.microsoft.com/blog/2012/11/05/announcing-new-system-views-for-windows-azure-sql-database/

Upvotes: 1

Related Questions