Re: Oracle SELECT triggers

In article <d7a6a759.0202251456.1d98b9dd_at_posting.google.com>, greg.arpino_at_webloyalty.com says...
>
>Does anybody know if Oracle has any plans to provide triggers on
>SELECT statements?
>
>I have a table that requires auditing. In addition to the standard
>data that Oracle records with Oracle auditing, I want to record
>certain application context related information and information from
>v$session such as program and module.
>
>Since oracle does not provide SELECT triggers in 8.1.6, I created a
>security policy on the table that is based on a function the inserts
>the required data into a separate auditing table that I created. The
>function returns NULL as the predicate.
>
>I cannot think of any reason why this is a bad alternative to a SELECT
>trigger, but if anybody else knows of a good reason, the input would
>be greatly appreciated.
>
>Regards,
>Greg

In 9i there is now fine grained auditing that provides for this facility.

http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88876/adgsec02.htm#1006527

...

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp