EBS Customizations (MOSC)
MOSC Banner

Automatically creating synonyms and execute privs

edited December 2014 in EBS Customizations (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center