Automatically creating synonyms and execute privs
Here is the situation
Customer is implementing R12.1.3 EBSO. Everyday customer is migrating customized code which basically creates some objects (packages, tables etc) in custom (XX) schema. Once the object is created in in the custom schema, if the object is a package or function then "execute" grants needs to be given to apps and synonym needs to be created under apps schema.
Many times, customer forgets to give the grants or create synonym in apps schema.
Question is: Is there any way that whenever any new object is created in custom (XX) schema, automatically grants will be given to apps user and synonym will be created in apps schema.