question

askQA avatar image
askQA asked

To get DBmail alert if Table accessed without trigger by some one or some other roles in SQL Server

hi SQL Server Central experts,


I have one question, i have a SQL Server databases with some tables, we have some separate user groups with roles and permissions, I need to get alert via DBmail stating loginame and access time and access table name if any one tried to access particular table without using Triggers can i achieve it like WMI event but it only allows create/drop/alter events only any suggestion would be highly appreciated

sql-servertable
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.