Hi,
This is oracle 11g database STANDARD EDITION (so, no FGA allowed).
I'm trying to refactorize some code and objects. This objects are accessed from a oracle forms app (forms, reports, and PL).
To make the things as smooth as possible, as I want to minimize errors happening at runtime , I'm thinking about converting a table that I want to drop in a view, so select statements against it won't fail.
In order to trap those selects and convert them to the new data model, it would be handy to have some audit procedure that tells me what module and action are trying to access my transient view, as forms and reports source files are binary, and it is not easy to look for references to the objects inside them.
A fine grained audit policy would be fantastic, but enterprise edition is off limits.
Any other idea?
Thanks.