Leo Torres
asked on
SQL Trigger
Would it be possible to write a trigger at the database level that looks at every table on the server and gathers the user name, Table name and action(select,Update,Inser t Delete)?
I would like to collect this data and store it in a table.
I would like to collect this data and store it in a table.
ASKER
OK got it so no selects then. This doc is Oracle i am referring to SQL. I would imagine its the same thing. Cant I create a DML trigger at the Database level?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://docs.oracle.com/cd/B19306_01/server.102/b14220/triggers.htm#i6061
and DML's are associated with tables...