Hello,
I'm trying to implement custom basic authentication to ORDS services using the ORDS prehook function, basically by following the example from the ORDS distribution examples (ords.zip/examples/pre_hook/sql).
The hook is called as expected (when calling an ORDS module which isn't protected by a privilege), authentication works, but when passing the CGI headers X-ORDS-HOOK-USER and X-ORDS-HOOK-ROLES so ORDS can properly authorize the user, I don't see them when I print all the headers in the ORDS handler by using the OWA_UTIL.print_cgi_env procedure? I assume I should see them there, and their values populated as expected?
The next problem I encountered is that when I try a HTTP call to an ORDS module which is protected by an privilege, my hook function doesn't get called?
Any ideas?
Using ORDS 18.3, Tomcat 9.0.13, Oracle 11g