and, still, you don't know who issued the "delete from myimportantdata where 1=1" or "update myimportantdata set dontdeletethiscolumn='' " just logging the queries. Have you by any chance looked into web2py's versioning ?
On Saturday, September 29, 2012 10:02:16 AM UTC+2, Mandar Vaze wrote: > > > >> if you need only the statements for the auth_user table it's a little >> overkill (and a lot les understandable, and you don't know, e.g. who >> modified the records). I'd stick with table versioning. > > > Not sure I completely understand what you mean, but my requirement is NOT > restricted to "who changed auth_user" entries. > I need "who updated/deleted" the other records in the system (There are > some master tables, there are some tasks etc.) > > So I need an ability to trace the changes that caused "unwanted" results > (Crucial data deleted for example - who and when ?) > > -Mandar > --
