Database Administration (MOSC)

MOSC Banner

What privilege is missing?

edited Sep 12, 2018 5:00AM in Database Administration (MOSC) 6 commentsAnswered

I have granted the user execute any procedure and the below execute privilege. However, when the user is executing the attached script, it is giving the below error. While running the script with apps user, the script runs fine without error. What privilege am I missing for the user?

grant execute on apps.WF_ENGINE to DATAEDIT_ROLE;

grant execute on apps.WF_PURGE to DATAEDIT_ROLE;

grant execute on apps.OE_STANDARD_WF to DATAEDIT_ROLE;

grant execute on apps.FND_CLIENT_INFO to DATAEDIT_ROLE;

grant execute on apps.FND_PROFILE to DATAEDIT_ROLE;

grant insert, update, select, delete on applsys.wf_items to DATAEDIT_ROLE;

Howdy, Stranger!

Log In

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

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