Hello all,
I've provisioned an Autonomous Database in Oracle Free Tier and I'm using the following components:
- Oracle APEX 19.1
- ORDS 19.1
What I'm trying to do is create a simple Oracle APEX application that uses ORDS to serve some images/videos located in the database.
When no security is in place everything work's OK, as the images are being shown beautifully. However, when I enable the security, the images stop showing.
I reviewed the ORDS development tutorial for 19.1 and it says on section "Modifying the Application to Use First Party Authentication" that you could achieve it by adding at the request URI the following:
- ?_apex_session=APP_ID,APP_SESSION_ID
- APP_ID: My App ID
- APP_SESSION_ID: My current session ID once logged
However, when I add the above, I'm still getting the ORDS 401 error, so it seems that ORDS isn't able to verify the cookie and therefore authenticate correctly with my Oracle APEX user.
Of course, when I enter my user/pass in the login prompt I'm able to see the images, so I guess that the Oracle APEX user configuration is OK.
Can anybody share any thoughts that might enlighten me? Could it be a limitation of the Autonomous Database (quite unlikely I think, but who knows...)?
Thank you beforehand for your time and patience.
Kind regards,
Sergio