Hi!
I have just uninstalled APEX/ORDS 19.1 and installed APEX/ORDS 19.2, in both a DB 18 and one 19. We deploy ORDS on WLS.
19.1 worked just fine but after new installation I get: 403 Forbidden - Access to the procedure named: apex is denied <- But it is granted to public in the DB
Have anyone experienced this and is there a solution?
Debug shows:
mapped request using: /*:PL/SQL to: |apex||
Choosing: oracle.dbtools.apex.ModApex as current candidate with score: PLSQLDispatchScore
==== Processing Request: ====
--Attributes--
- weblogic.servlet.network_channel.port = 9001
- oracle.dms.context.http.WebRequestContextProcessed = 1
and so on ending with:
Checking procedure <apex> exclude= false
Procedure DENIED with Error code: 403
==== Request Processed ====
[TE] GET /ords/ start: 2019-11-19T13:31:20.857Z duration: 44ms
Or with curl:
* About to connect() to IP port 9001 (#0)
* Trying xxx.xxx.xxx.xxx...
* Connected to xxx.xxx.xxx.xxx (xxx.xxx.xxx.xxx) port 9001 (#0)
> GET /ords/ HTTP/1.1
> User-Agent: curl/7.29.0
> Host: xxx.xxx.xxx.xxx:9001
> Accept: */*
>
< HTTP/1.1 403 Forbidden
< Date: Tue, 19 Nov 2019 13:23:44 GMT
< Content-Length: 24956
< Content-Type: text/html
< X-ORACLE-DMS-ECID: 383629e7-46ee-45e6-a14c-c595cd38ce4d-000001b3
< Error-Reason: error="procedure"; error_description*=UTF-8''Access%20to%20the%20procedure%20named%3a%20apex%20is%20denied.%20
< X-ORACLE-DMS-RID: 0