Whenever the “SELECT” command execution happens irrespective of any table inside one particular database Log information into one Log table.
The Information required
1) User logged in
2) Machine details
3) Table Name
4)
In My DB there were more than 100 tables. I want to Wright single trigger like "DDL trigger" to know what are tables are got executed at which time, by which user and from which machine.
Reg,
- Karthick