Single Trigger for "SELECT" execution happens irrespective of any table.

[jvskarthick]

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

[ck9663]

I don't think SELECT are logged. Select also is not an event, which means it can not fire a trigger. If you see one, kindly post it here...

-- CK