Audit enable on a table for select , delete ,insert

https://bradmcgehee.com/2010/03/30/an-introduction-to-sql-server-2008-audit/

db_owner -> nly owner can see the data in the audit file.

public -> it gets inserted in the audit file


To read from the Audit file

SELECT top 10 * FROM sys.fn_get_audit_file ('E:\DBA\PrismAuditForPTR_9D053EB5-1A04-473C-A5DB-7F5A6779B8F6_0_132258070574800000.sqlaudit',default,default);   

SELECT  top 50 statement
FROM sys.fn_get_audit_file
('E:\DBA\PrismAuditForPTR_9D053EB5-1A04-473C-A5DB-7F5A6779B8F6_0_132258070574800000.sqlaudit',
default,default) where database_principal_name<>'NA\crmdbsvc'

Comments

Post a Comment

Popular posts from this blog

CT and CDC Info

Checking CDC SELECT name FROM sys.tables where is_tracked_by_cdc=1 SELECT s.name AS Schema_Name, tb.name AS Table_Name , tb.object_id, tb.type, tb.type_desc, tb.is_tracked_by_cdc FROM sys.tables tb INNER JOIN sys.schemas s on s.schema_id = tb.schema_id WHERE tb.is_tracked_by_cdc = 1 and s.name+'.'+tb.name in ('dbo.areas','dbo.ComponentTags','dbo.Images','dbo.Productlines', 'focalpoint.RadioFrequencyCards','taxman.Chipsets','Masterdata.Components','Masterdata.SoftwareFormats', 'Qswat.Areas','Qswat.Products') order by 1 Enabling CDC on DB : EXEC sys.sp_cdc_enable_db Enabling CDC on Table: EXEC sys.sp_cdc_enable_table  @source_schema = N'dbo',  @source_name   = N'Test', @role_name     = NULL Disable CDC EXEC sys.sp_cdc_disable_table  @source_schema = N'dbo',  @source_name   = N'Test', @capture_instance  =...
Read more