ORDS Create Basic Authentication for a RESTful Web Service

ORDS Basic Authentication 1. To protect the web service, we need to create a role with an associated privilege, then map the privilege to the web service BEGIN ORDS.create_role( p_role_name => 'boomi_role' ); COMMIT; END; / -- Display the role. COLUMN name FORMAT A20 SELECT id, name FROM user_ords_roles WHERE name = 'boomi_role'; ID NAME … Continue reading ORDS Create Basic Authentication for a RESTful Web Service

ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named

ORDS Version : 18.2 Oracle Version : 12cR2 Error : The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named HR Desc: The error occurs when you have published a RESTful web service from a table inside a schema. When you try to call the Webs service … Continue reading ORDS 18.2 – The database user for the connection pool named apex_pu, is not authorized to proxy to the schema named

Enable SSL Certificates for Oracle Apex 18.1 with Oracle Rest Data Services (ORDS) 18.1 hosted on Apache Tomcat 9

If you have a public facing APEX instance it would be mandatory to secure it with TLS 1.2 or SSL. If you want to enable https for a public facing web server, it's always recommended to use a public certificate authority or at-least use Lets encrypt to generate certificates.Self-signed certificates are not to be put … Continue reading Enable SSL Certificates for Oracle Apex 18.1 with Oracle Rest Data Services (ORDS) 18.1 hosted on Apache Tomcat 9

Upgrade Oracle Apex from 5.1.x to 18.1

Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from version 5.1.4 to 18.1 . The new version of Apex has many exciting new features, you can read about them all here Setup : Apex Version : Oracle Apex 5.1.4 Webserver : ORDS Running on … Continue reading Upgrade Oracle Apex from 5.1.x to 18.1

Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1

Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex can be run directly from the database engine itself using a component called Mod PL/SQL. It is one of the easiest way to run Apex, but it is not a production ready setup. In a … Continue reading Install Oracle Apex 5.1.x, 18.1 on ORDS 3,17.4, 18.1