Hello,
I've run into a straightforward but tedious permission issue on Oracle Cloud.
I have an Apex 24.1 app and Oracle Database 23c on the cloud.
After recently migrating my application and database from on-premises to the cloud, I encountered the following error when clicking on the pages in the Apex application:
Ajax call returned server error ORA-41900: missing EXECUTE privilege on "APEX_240100"."WWV_FLOW_SECURITY" for FacetSearch.
I thought this would be a straightforward grant issue, so I logged into the SQL page on the cloud using an ADMIN account and tried to grant privileges. However, it resulted in an error indicating insufficient privileges.
GRANT EXECUTE ON APEX_240100.WWV_FLOW_SECURITY TO SVCAPP;
ORA-01031: insufficient privileges Error at Line: 7 Column: 0
Could you please advise on how to resolve this issue? Is there a sys wrapper on the cloud that I can use to grant permission?
Thank you