472,145 Members | 1,492 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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

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
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.

- Karthick
Feb 11 '09 #1
1 1565
2,878 Expert 2GB
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
Feb 13 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

23 posts views Thread by ian justice | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.