Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Technology Stack - EBS (MOSC)

issue during Db user copy of APPS in 12.2.4

Oct 31, 2016 10:53AM edited Nov 8, 2016 4:00AM in Technology Stack - EBS (MOSC) 1 commentAnswered ✓

My customer has a requirement to create an APPS_XXX DB user as a copy of APPS user (not a read_only version of apps but a true copy with the same rights as APPS).

usually, until 12.2.3 version, i was generally doing something like that:

1. Create user apps_XXXX with appropriate roles and system privileges

2. run a script to give grants on all apps objects to apps_xxxxx

3. Write an after logon trigger on apps_xxxx schema to set current schema to apps for the session

Unfortunately, this procedure doesn't work anymore with EBR enabled on the DB. When i'm trying to grant apps views to apps_xxx i get this kind of errors:

Tagged:

EBS-ATG-TechStack

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

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

Category Leaderboard

Top contributors this month