Discussion on "How to implement a dynamic Authorization Scheme in Oracle APEX?"

Louis Moreaux · 2023-03-09T12:17:14.678Z

Introduction In almost every Oracle APEX application, we need to set up authorization schemes to manage access to pages, buttons, processes, etc... This post will explain how it is possible to build a dynamic authorization allowing your users to upda...

Great and really sorry that doesn't work for lists, menu, breadcrumbs... I mean that APP_COMPONENT_NAME is empty for that.

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

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

Thanks Feras Tamesh 🙏

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

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

Salut Louis

Merci pour le partage, ca pourra servir !

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

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!

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

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

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

Louis Moreaux Do you happen to know of a blog post about this? Or maybe a future topic for you :) :)

Michael Ellerbeck 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.

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

Thank you Jon, I really appreciate the comment 🙏

Search Hashnode

How to implement a dynamic Authorization Scheme in Oracle APEX?

Responses6