Audit FSG Reports
I asked this question in the database message board and they suggested I post it into an application based one instead. Hopefully someone can help me.
Does anyone know if it is possible to create an audit trail against a view in Oracle? All the guides I've read describe how to setup audit trails on tables but it would be easier and more user friendly if we could use a view.
What I'm trying to do is monitor all the changes that are made to our FSG reports via the various forms. If I look at the data in the forms I can see that it is held in different views based off the tables with the "RG" prefix. Therefore putting an audit trail on the view would make things easier than putting it on a table.