Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008: Audit, DML... Expand / Collapse
Author
Message
Posted Thursday, January 22, 2009 6:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 1:10 PM
Points: 109, Visits: 79
Hello People, What level audit for capture operations DML?
for example, this picture:
http://img165.imageshack.us/my.php?image=auditoriapv4.jpg
i'm need make put SSMS and not via t-sql...

in T-SQL, this code:
....
CREATE DATABASE AUDIT SPECIFICATION [Auditoria_DML]
FOR SERVER AUDIT MinhaAuditoria_File
ADD (SELECT, INSERT, UPDATE, DELETE
ON HumanResources.EmployeePayHistory
BY PUBLIC),
ADD (SELECT, INSERT, UPDATE, DELETE
ON Sales.CreditCard
BY PUBLIC)
WITH (STATE = ON)
GO

but, using SSMS i'm do know...
Post #641668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse