"Read" Triggers

[timofe]

Are there such things as Read Triggers in Oracle 8i?

My requirement is to write an entry to a transaction table every time a user views a row in a billable table (i.e. a pay-per-view system).

It occurs to me that a row-level trigger based on the user reading an entry in the transaction table would satisfy the requirement, but the last time I used triggers was four years ago and I don't remember "Read" being an option then.

Can anyone help?

 

[sem]

You may provide access to table data through procedure that makes all necessary audit.

 

[kindus]

No, You cann't create trigger on select or read. I think what you need is to put audit on for those tables, design your app based on audit information. You can definitely audit for select/read for tables you need for users you want.
Hope it helps!