Automatic Grant of Synonym's of tables/views as they are created
When a table or view is created we manually execute a scripted stored procedure that creates a public 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 the database to automate the creation of the synonyms so it is done automatically when a table or view is created?
We have had an Oracle automatically triggered stored procedure in the past, but found it was creating processes that did not always complete
1