[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Audit select on a table

I need to know who acceses a salary table.
I want audit any dml on that table.
Can this be done? If so, how do I do it?
Thanks
0
praimsankar
Asked:
praimsankar
  • 2
1 Solution
 
Saqib KhanSenior DeveloperCommented:
what if you create a Trigger on that Table and Track the Users ID upon DML.
0
 
praimsankarAuthor Commented:
Is it possible to create a trigger on a 'SELECT'  event ??
I was looking for a better answer than a what if.
 
0
 
Saqib KhanSenior DeveloperCommented:
nope.
only Update, Delete or Update. and I think thats what you wand DML.
I dont think there is another way,
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now