Dear Freinds,
we are having an requirement to log the unauthorized backend update on database.Is there any other way ,apart from going and creating the triggers at each table to log the backend update.
Note :Is Database base level trigger is possible on SQL Server 2000?
Looking for your reply.
With Cheers :beer: ,
Sathesh.MNo, database-level triggers are not implemented in 2000.
And the way to handle unauthorized backend updates is with proper security.|||Dear Blindman,
We are having all level of database security,there are 40 support people
working on this pro.,we want to track there updation also.
With Regards,
Sathesh.m|||You'll need to put triggers on the individual tables.
Every table I create contains columns for MODIFIED and MODIFIER, with an update trigger to set them to GETDATE() and SUSER_SNAME().
No comments:
Post a Comment