Srini, thank you for such a useful and beautiful piece of code!
1. However, when I ran the script and then the sproc, I found it only created log_tables for 17 out of 75 user tables. Any idea why?
2. At the risk of sounding ungrateful, though, I would like to request an enhancement that would greatly add value to the log table: The current script logs the affected record with the activity flag, but it does not show the date/time stamp the activity occurred or the user responsible.
I would have adapted your code to include these features, IF I could make sense of it. Would it be asking for too much to have them included?
Experience is a bad teacher whose exams precede its lessons