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.
Tagged:
0