1

Topic: About audit SQL

Dear colleagues!
Nobody knows, whether there is an audit in the version
Microsoft SQL Server 2014 (SP2-GDR) (KB3194714) - 12.0.5203.0 (X64) Sep 23 2016 6:13:56 PM
Copyright (c) Microsoft Corporation A Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
I thank in advance for comments!)

2

Re: About audit SQL

The abstract audit? Or any specific?

3

Re: About audit SQL

Gavrilenko Sergey Alekseevich, granular

4

Re: About audit SQL

Gavrilenko Sergey Alekseevich, granular that I could write down broad gulls in log of safety of OS

5

Re: About audit SQL

Probably to answer "is" enough

6

Re: About audit SQL

It seems is not present, look?
Probably somewhere it is adjusted still?

7

Re: About audit SQL

It is written by Russian that in your edition of the server it is inaccessible.

8

Re: About audit SQL

More shortly, it is necessary to it DATABASE AUDIT.
And edition STANDARD.
And to 2016 SP1 it in  is not present, an Enterprise Edition only

9

Re: About audit SQL

Thanks!
(

10

Re: About audit SQL

Pancake, Enterprise Edition expensively! (((

11

Re: About audit SQL

Mari-Salt;
To you it is necessary was specific application role change_password group? Or can more in detail that is necessary

12

Re: About audit SQL

TaPaK, I Want to create for auditors a broad gull in OS that could watch changes at DB level. Was specific: when operator Create, Alter, Drop, delete over objects is fulfilled.

13

Re: About audit SQL

Mari-Salt wrote:

when operator Create, Alter, Drop, delete over objects is fulfilled.

For this DDL-trigger suffices

14

Re: About audit SQL

Yasha123;
In log of safety of OS! wink

15

Re: About audit SQL

Mari-Salt;
Well write in application log, xp_logevent.

16

Re: About audit SQL

Yasha123 wrote:

Mari-Salt;
Well write in application log, xp_logevent.

Thanks and as it is possible to connect here events of level of the server (Database_Change_group, Database_object_Change_group, Delete, update) and

17

Re: About audit SQL

Yasha123 wrote:

Mari-Salt;
Well write in application log, xp_logevent.

Excellent idea! Thanks!)))