Dear Experts
I have made a server security audit and specify from database audit specification to audit "select" on a certain user and on a certain table. I logged in by this user and made the select statement
when i run this query "select * from sys.fn_get_audit_file('d:\Audit\audit1*',null,null)"
it return a value at which time the query has done
after 15 minutes i repeated the same action, i run the audit query and the same result is showed off on the panel
is it suppose to return a list of values by how many times this user has made the select statement on that table ?
for example at 5:00 pm then 6:00 pm and so on
Thanks lot