---
title: "Discussion on \"How to implement a dynamic Authorization Scheme in Oracle APEX?\" | Hashnode"
description: "Discussion on \"How to implement a dynamic Authorization Scheme in Oracle APEX?\". This post explains how to build a dynamic authorization scheme in an Oracle APEX application allowing your users to update their rights"
url: "https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b"
---

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

Discussion

# [How to implement a dynamic Authorization Scheme in Oracle APEX?](https://lmoreaux.hashnode.dev/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

This post explains how to build a dynamic authorization scheme in an Oracle APEX application allowing your users to update their rights

Mar 9, 2023 · 7 min read · lmoreaux.hashnode.dev  
Updated Mar 11, 2023  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#plsql](https://hashnode.com/tag/plsql)
-   [#authorization](https://hashnode.com/tag/authorization)

## Written by

[Louis Moreaux](https://hashnode.com/@lmoreaux)

@lmoreaux · Paris

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

Oracle APEX developer

Oracle APEX Developer (Insum) from Paris Contributor of Flows for APEX Passionate about APEX and web development.

## Responses 6

Markdown supported · ⌘↵ to post

[Sasha Gomanuke](https://hashnode.com/@gomanuke)

[Apr 22, 2025](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/68072a73ff16b1a86051ca38)

Great and really sorry that doesn't work for lists, menu, breadcrumbs... I mean that APP\_COMPONENT\_NAME is empty for that.

[data science](https://hashnode.com/@datasci)

[Apr 8, 2024](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/6613eeb733315e110adfab09)

Thanks for this. I keep getting this error in the dynamic authorizasion code step: ORA-06550: line 1, column 124: PLS-00103: Encountered the symbol "CREATE" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json\_exists json\_value json\_query json\_object json\_array

[Feras Tamesh](https://hashnode.com/@ferastamesh)

[Feb 25, 2024](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/65db4344534aa917a56862e2)

It's very helpful, Apex Documentation didn't explaine it as you did. Thank you.

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 1, 2024](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/65db4344534aa917a56862e2#reply-65e21b682e07e97e90f4bb51)

Thanks [Feras Tamesh](https://hashnode.com/@ferastamesh) 🙏

[Gökhan Doğan](https://hashnode.com/@bugiboxi)

[Apr 7, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/642fd3b019dd2f34ad7fb298)

Hi, Louis, This article is very clear and useful. I benefited a lot. Thank you for sharing.

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Apr 11, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/642fd3b019dd2f34ad7fb298#reply-643503c3fefbae6a6f560ac5)

Hi Gökan, Thank you for your comment, I truly appreciate it!

[Eric Nougayrede](https://hashnode.com/@EricNougayrede)

[Mar 22, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/641ac5b68cda7e11ee56293b)

Salut Louis

Merci pour le partage, ca pourra servir !

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 22, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/641ac5b68cda7e11ee56293b#reply-641b2f4ec7ed89196afa494f)

Salut Eric, Merci pour le commentaire, c'est toujours agréable et je suis très heureux que tu aies apprécié le contenu.

[Juan López García](https://hashnode.com/@JuanL)

[Mar 15, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/64122d530dd7cb923f693c9d)

I really enjoyed the post!! Thanks for the reading, and I'll tell you a bit more once I code it to have a deeper look!

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 16, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/64122d530dd7cb923f693c9d#reply-6412d3f2ab81b092709ad74d)

Thank you for taking the time to drop a comment! I can't wait to see what you will do with it 🤩

[Michael Ellerbeck](https://hashnode.com/@mellerbeck)

[Mar 9, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/640a28216b5ccef6ff210b9f)

Have you ever played with making this work with SSO \\ Basic Auth

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 9, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/640a28216b5ccef6ff210b9f#reply-640a47543e0c5ff6cf7f8c87)

Yes, I get it working with basic authentication and a custom user\_role table. I don't see any reason why it will not be possible to use it with SSO

[Michael Ellerbeck](https://hashnode.com/@mellerbeck)

[Mar 10, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/640a28216b5ccef6ff210b9f#reply-640b6b15f7588f27e26c3369)

[Louis Moreaux](https://hashnode.com/@lmoreaux) Do you happen to know of a blog post about this? Or maybe a future topic for you :) :)

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 11, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/640a28216b5ccef6ff210b9f#reply-640c9992bf33d83cdec15102)

[Michael Ellerbeck](https://hashnode.com/@mellerbeck) Sadly, there are only a few references about these authorization scheme evaluation points. But if you store your roles in a custom table, it should be straightforward to implement it. The authorization scheme is not dependent on the authentication scheme to me.

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

[Mar 9, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/6409dc543e0c5ff6cf7f7ec5)

Clear and well-thought-out post on a very useful feature. Thank you.

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Mar 9, 2023](https://hashnode.com/posts/how-to-implement-a-dynamic-authorization-scheme-in-oracle-apex/6409ce4a57290ddcb5c5430b/comment/6409dc543e0c5ff6cf7f7ec5#reply-640a46d33e0c5ff6cf7f8c64)

Thank you Jon, I really appreciate the comment 🙏
