Automatic Granting of Synonyms of tables/views when they are created/altered
When a table or view is created or altered we manually execute a scripted stored procedure in Oracle that creates a synonym to allow developers that do not have a sysadm login to be able to select from the table or view. Is there a process that can be implemented in Peopletools or Oracle database to automate the creation of the synonyms so it is done automatically when a table or view is created or altered?
We have had a Oracle automatically triggered stored procedure in the past, but found it was creating processes that did not always complete
1