Full Version: Trigger on Select statement
Sir, Is it possible to bulid a trigger in order to make it fired when one executes a select query on some table..?
No. Triggers are created on DML statements (i.e. insert/update/delete). See here http://www.dba-oracle.com/t_ddl_triggers.htm
If you're interested in knowing who selects against an object consider Fine Grained Auditing - http://www.dba-oracle.com/security/fine_grained_auditing.htm
If you're interested in knowing who selects against an object consider Fine Grained Auditing - http://www.dba-oracle.com/security/fine_grained_auditing.htm
QUOTE (Brian Carr @ Mar 11 2010, 05:47 PM) 
No. Triggers are created on DML statements (i.e. insert/update/delete). See here http://www.dba-oracle.com/t_ddl_triggers.htm
If you're interested in knowing who selects against an object consider Fine Grained Auditing - http://www.dba-oracle.com/security/fine_grained_auditing.htm
If you're interested in knowing who selects against an object consider Fine Grained Auditing - http://www.dba-oracle.com/security/fine_grained_auditing.htm
Thank you for the above information. I got some idea about Fine grained Auditing, Thanks a lot..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.