---
title: "Discussion on \"Best Practices for Building ORDS PL/SQL-Based REST APIs\" | Hashnode"
description: "Discussion on \"Best Practices for Building ORDS PL/SQL-Based REST APIs\". Best Practices for Building Oracle REST Data Services (ORDS) PL/SQL Based REST APIs"
url: "https://hashnode.com/posts/ords-plsql-based-rest-api-bp/64b92aa375c2d6a23fe6a54f"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Best Practices for Building ORDS PL/SQL-Based REST APIs](https://blog.cloudnueva.com/ords-plsql-based-rest-api-bp?utm_source=hashnode&utm_medium=feed)

Best Practices for Building Oracle REST Data Services (ORDS) PL/SQL Based REST APIs

Jul 20, 2023 · 11 min read · blog.cloudnueva.com  
Read the article

-   [#oracle](https://hashnode.com/tag/oracle)
-   [#ords](https://hashnode.com/tag/ords)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 2

Markdown supported · ⌘↵ to post

[Jose Aróstegui](https://hashnode.com/@josearostegui)

[Dec 3, 2024](https://hashnode.com/posts/ords-plsql-based-rest-api-bp/64b92aa375c2d6a23fe6a54f/comment/674f3e85b1456ec499e1bb71)

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!

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 4, 2024](https://hashnode.com/posts/ords-plsql-based-rest-api-bp/64b92aa375c2d6a23fe6a54f/comment/674f3e85b1456ec499e1bb71#reply-675032f1a1675bd94b524921)

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.

[Osvaldo González](https://hashnode.com/@OsvaldoGonzalezPy)

[Jul 20, 2023](https://hashnode.com/posts/ords-plsql-based-rest-api-bp/64b92aa375c2d6a23fe6a54f/comment/64b962f3a884f3de56a26ef7)

Excellent post as always, quite useful information

[Jon Dixon](https://hashnode.com/@orclapex)

[Jul 21, 2023](https://hashnode.com/posts/ords-plsql-based-rest-api-bp/64b92aa375c2d6a23fe6a54f/comment/64b962f3a884f3de56a26ef7#reply-64b9f6c6af9957de87411bd3)

Thank you Osvaldo.
