July 27, 2009 at 6:36 pm
I am trying to identify the users accessing time in a particular period of time.
Yes I can use activity monitor , but I would like to get an email alert when a user accessed a particular database.
Say the user USER1 , who had read and write access, can access a the webpage.
When the users access the database DB1, like any acitivity ( Read or write ) in database should trigger an email.
How can i do that.
Thanks.
BJ
July 27, 2009 at 8:19 pm
You really can't do what you are asking. You can audit logins/logouts or run a server-side trace to audit the database, but there is no way to trigger an action based on a select (read).
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 28, 2009 at 12:09 am
Audit login means, with event viewer ?? OR any other scripting?
Could you explain a bit more?
July 28, 2009 at 12:12 am
Audit login means, with event viewer ?? OR any other scripting?
Could you explain a bit more?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply