From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Query the SQL Server audit log - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Query the SQL Server audit log
- [Narrator] In the previous movie, we set up a server audit that showed log any time someone impersonates another user in the Wide World Importers database, as well as when a DBO user selects records from the Warehouse.Stockitems table. We'll see if it's working correctly and see how to retrieve information from the logs. Now, first, I want to go into the Wide World Importers database inside of the Object Explorer and expand the Security folder. Then, we'll find the database audit specifications folder, and find the audit that we're working with. Here, it's called Audit Wide World Importers. If you don't have this file here, go ahead and review the steps that we did in the Create an Audit on SQL Server Movie. This is the audit that we're going to test out. Let's try it out by starting in the Wide World Importers database, and we'll select everything from the Warehouse.Stockitems table as the DBO account. Next, I'll run another select statement, we'll select everything from…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.