Tracking all DML and DDL Statements in Database Tables

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ScarletPimpernal
    New Member
    • Mar 2007
    • 39

    Tracking all DML and DDL Statements in Database Tables

    Hi Friends,

    I want to know one thing, i have a database which contains few tables and few default records in that.

    Sometimes unusually some developer is truncating the tables or else dropping the table without my knowlege.

    How can i track these changes in my database?

    Any answers will be most welcome and useful for me.

    In Oracle, i heard that there are DDL and DML Triggers available but iam new to MYSQL. can anyone tell me is that any functionality available in MYSQL?

    Thanks
Working...