Discussion

Jon Dixon

APEX, ORDS & the Oracle Database

Jul 20, 2023

Best Practices for Building ORDS PL/SQL-Based REST APIs

Introduction Oracle REST Data Services (ORDS) is a robust and highly scalable tool for exposing REST APIs on top of the Oracle Database. ORDS has several features that allow you to quickly create REST APIs, not least of which is the ability to create...

blog.cloudnueva.com11 min read

#oracle #ords

Responses(2)

JA

Jose Aróstegui

Dec 3, 2024

Great post Jon, sure I'll apply your recommendations to my customers.

Don't you like the privileges/roles/mapping standard so you don't mention it? You skip the use of it with your custom tables (system_permissions)?

Thanks!

Hi. I find that Privileges/roles mapping works well for allowing access to certain web services but not as well for allowing access to specific data within a web service. This is why I went with my own tables in this case.