i have this problem:
i need to create SQL SERVER Audit (just SELECT) for 1 table using APPLICATION LOG for a windows domain group which include 4 domain accounts.
This domain account used by dba's.
Below are the commands that i am using.
When i am using this group below and select from the table i don't see anything in the application log,
but when i use dbo instead of [Domain\DBAs] i can see the logs are generated in the application log.
Is there something that i am missing?
CREATE SERVER AUDIT audit_Customer TO application_LOG
WITH ( QUEUE_DELAY = 1000,ON_FAILURE = CONTINUE);
ALTER SERVER AUDIT audit_Customer
WITH (STATE = On)
CREATE DATABASE AUDIT SPECIFICATION audit_select_Customer
FOR SERVER AUDIT audit_Customer
ADD (SELECT ON dbo.Customer by [Domain\DBAs])
WITH (STATE = ON)
ALTER DATABASE AUDIT SPECIFICATION audit_select_Customer