Is it possible to create a trigger that fires when a view is created on a user schema?
I want to create a meta data table which will hold all the views and a listing containing what they are supposed to do. In this system (Oracle 220.127.116.11) there is only one user who has the create view privilege so that may make it easier.
The sequence of events should be something like view is created trigger fires and inserts the name of the view in the table of meta data table
I could write up some package to create views using dynamic sql but that seems a bit of overkill