Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Apex permission DB error

Nikhil Kumar5 days ago — edited 5 days ago

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

Comments
Post Details
Added 5 days ago
2 comments
47 views