APEX Version: 24.1.6
We are switching to using Active Directory (on premises, so no Entra) for our authentication. I figured out how to do it, mostly from this one article.
Now, however, I need to create authorization schemes. These authorization schemes would need to provide authorization based on the signed-in users department, mainly, but possibly other attributes such as AD groups, etc.
I've researched a bit online, but am having trouble finding any guides on how to implement authorization schemes specific to Active Directory. One route that seems like it could work is using the DBMS_LDAP package to query the Active Directory.
However, I'm wondering A) whether there are any easier / out-of-the-box ways, and, if not, B) what would be a recommended strategy for implementing AD authorization schemes?