You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to call DBMS_CLOUD but EXECUTE grant was removed

Summary:

One of our customers has two ATP instances with DBMS_CLOUD, they have several PL/SQL packages where they call DBMS_CLOUD without issues until last week where in one of the instances they started to get below error when trying to compile one of the PL/SQL package:

PLS-00904: insufficient privilege to access object PUBLIC.DBMS_CLOUD

We have compared both instances and noticed that ADMIN user does not have EXECUTE grant on DBMS_CLOUD and that is the reason for above failure, find below the details from USER_TAB_PRIVS with the expected grant.

We do not know what happened but need to provide again the EXECUTE grant to ADMIN user.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!