Secure RESTful Web Service in Oracle APEX with Basic Authentication
Heard they say you should secure your web service? 👮 Stick with me in this article, and I’ll show you a professional way to secure your RESTful Web Service with Basic Authentication In the previous article, I explained how to CREATE a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this Article I will shows you how to build a professional, secure JSON RESTful web service in Oracle APEX that returns employee details from the HR.EMPLOYEES table, protected by Basic Authentication with PBKDF2 password hashing. Prerequisites Oracle Database 19c or later Oracle APEX 21.1 or newer HR sample schema unlocked and available EXECUTE on DBMS_CRYPTO A workspace with privileges to create RESTful Services 🚴 Let's GO Step 1 – Create a Table to Store Web Service Users CREATE TABLE ws_users ( username VARCHAR2 ( 100 ) PRIMARY KEY, password_hash VARCHAR2 ( 64 ) NOT NULL , -- ...