SQL Server Audit (Audit) configuration Method--database-level auditing

Source: Internet
Author: User

Approximate steps:

A. Create an audit

B. to create a database-level audit specification - creation, deletion and modification of monitoring database objects

C. Test Auditing features - Create, modify, and delete database objects

D. Use the log file Viewer to read the audit log


1.   Create an audit

Right-click on the audit - New Audit

under audit name: audit-database

Audit File: File

file path: C:\Myadmin\audit_logs

650) this.width=650; "title=" 11.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/4B/ Wkiol1sugeuzgoiuaajepbhpgto276.jpg "alt=" Wkiol1sugeuzgoiuaajepbhpgto276.jpg "/>

and start auditing Audit-database

650) this.width=650; "title=" 12.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/4E/ Wkiom1suf4qykioraagifgi03tu464.jpg "alt=" Wkiom1suf4qykioraagifgi03tu464.jpg "/>

2.to create a database-level audit specification-monitoring the creation, deletion and modification of database objects

Expand Database ->accdb Database Security - Database Audit Specification -- Right-click the new database Audit specification

650) this.width=650; "title=" 13.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/58/4E/ Wkiom1suf4qddbq-aajicj4ma5g338.jpg "alt=" Wkiom1suf4qddbq-aajicj4ma5g338.jpg "/>

in the Create Database auditspecification Enter database audit name on interface databaseauditspecification

Click Audit " Audit-database "

in the Audit action type, select: Schema_object_change_group

Schema_object_change_group is a database-level audit Action group that executes on the schema Create\alter\

Drop action, this event is raised

650) this.width=650; "title=" 14.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/58/4B/ Wkiol1sugeyiorviaappsn21kmm874.jpg "alt=" Wkiol1sugeyiorviaappsn21kmm874.jpg "/>

Start the Database Audit specification

650) this.width=650; "title=" 15.png "style=" Float:none; "src=" Http://s3.51cto.com/wyfs02/M01/58/4E/wKiom1SuF4rA7l3 _aahlztp6h1k462.jpg "alt=" Wkiom1suf4ra7l3_aahlztp6h1k462.jpg "/>

3.Test Auditing features-objects that create, modify, and delete databases ---- Creating database Objects

650) this.width=650; "title=" 16.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/58/4B/ Wkiol1sugezt3o9faajd38ftqio282.jpg "alt=" Wkiol1sugezt3o9faajd38ftqio282.jpg "/>

--- modify some of the database objects that you created earlier

650) this.width=650; "title=" 18.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/58/4E/ Wkiom1suf4rxv1zaaac0qk-88by096.jpg "alt=" Wkiom1suf4rxv1zaaac0qk-88by096.jpg "/>

---- to delete a database object that was previously created

650) this.width=650; "title=" 19.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/58/4B/ Wkiol1sugeyzflataadr-ud33by143.jpg "alt=" Wkiol1sugeyzflataadr-ud33by143.jpg "/>

4.Use the log file Viewer to read the audit log

in the "Security" - The auditing node

Right-click Audit: Audit-databse, Click "View audit Log"

650) this.width=650; "title=" 20.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/4B/ Wkiol1suge2aergxaainhkwdiq4898.jpg "alt=" Wkiol1suge2aergxaainhkwdiq4898.jpg "/>

in the Select Log Hook option " Audit-database "To view detailed operational logging

650) this.width=650; "title=" 21.png "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M00/58/4E/ Wkiom1suf4uivjhlaazr1krmsym086.jpg "alt=" Wkiom1suf4uivjhlaazr1krmsym086.jpg "/>


SQL Server Audit (Audit) configuration Method--database-level auditing

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.