Audit Trail

Reply
Contributor
Posts: 43

Audit Trail

Hello!

I am thinking about implementing an audit trail on MySQL which would work with triggers. Does somebody know if the triggers work when I do an SQL update/insert/delete statement directly from SAS to MySQL?

Thanks!
Contributor
Posts: 44

Re: Audit Trail

They should, but you may want to consider doing the audit trail a different way as triggers can slow down your performance significantly.

If you can grab the audit information (userID, date, etc...) prior to doing the insert/update, then you could put that information into the SQL statement and not rely on the database to do the work.
Post a Question
Discussion Stats
  • 1 reply
  • 240 views
  • 0 likes
  • 2 in conversation