CREATE TABLE tab1 (id int, mess varchar(10))

USE master
GO
--===========================================================================================
--          О Б Ъ Е К Т   А У Д И Т А
--===========================================================================================
IF EXISTS (select 1 from sys.server_audits where name = 'SrvAudit_File') BEGIN
   ALTER SERVER AUDIT SrvAudit_File WITH (STATE=OFF)   
   DROP SERVER AUDIT SrvAudit_File
END

CREATE SERVER AUDIT SrvAudit_File TO FILE (FilePath = N'd:\Work\Audit')
ALTER SERVER AUDIT SrvAudit_File WITH (STATE=ON)   

--===========================================================================================
--          О Б Ъ Е К Т   С П Е Ц И Ф И К А Ц И Я   А У Д И Т А   Б Д
--===========================================================================================
USE test1
GO
if EXISTS (select 1 from sys.database_audit_specifications where name = 'SrvAuditSpec_File') BEGIN
   ALTER DATABASE AUDIT SPECIFICATION SrvAuditSpec_File WITH (STATE=OFF)
   DROP DATABASE AUDIT SPECIFICATION SrvAuditSpec_File;
END
CREATE DATABASE AUDIT SPECIFICATION SrvAuditSpec_File FOR SERVER AUDIT SrvAudit_File;

ALTER DATABASE AUDIT SPECIFICATION SrvAuditSpec_File ADD (SELECT ON dbo.tab1 BY user1)   

ALTER DATABASE AUDIT SPECIFICATION SrvAuditSpec_File WITH (STATE=ON)

select * from test1..tab1

SELECT *
  FROM fn_get_audit_file('d:\Work\Audit\*', null, null) 
 WHERE not (action_id = 'AUSC' AND class_type = 'A')  
 ORDER BY event_time DESC

ALTER DATABASE AUDIT SPECIFICATION SrvAuditSpec_File ADD (SELECT ON dbo.tab1 BY user1)

ALTER DATABASE AUDIT SPECIFICATION SrvAuditSpec_File ADD (SELECT ON dbo.tab1 BY dbo)

IF EXISTS (SELECT 1 FROM sys.server_principals WHERE name = N'user1' ) DROP LOGIN user1
CREATE LOGIN user1 WITH PASSWORD='123'
EXEC sys.sp_addsrvrolemember @loginame = user1, @rolename = N'sysadmin'
GO
USE test1
GO
IF  EXISTS (SELECT 1 FROM sys.database_principals WHERE name = N'user1') DROP USER user1
CREATE USER user1 FOR LOGIN user1 WITH DEFAULT_SCHEMA = dbo

select @@version