How to Restore the Grant After the Privileges Have Been Revoked

(Doc ID 1268276.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.1.2 to 4.0.0.00.40 [Release APEX 3.1.2 to 4]
Information in this document applies to any platform.
***Checked for relevance on 1-Oct-2012***

Goal

APEX has stopped working because privileges were revoked. Show the step to grant back the proper privileges.

Note that the symptoms of this problem normally are:

1. Users can successfully log into the APEX Builder.
2. When attempting to run an APEX application the following error occurs ->

 


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms