We want to perform a custom SQL query (stored procedure would be even better) on Oracle DB and return result (string) as a response.
After successfull authentication and authorisation performed against AD User Store we need to send extra data in the response that is stored in the Oracle DB.
The data in Oracle is not related to user schema - just a reference data about the Group that we want to provide to the Web application.
I've looked at DN attribute, however this seems to require User Store, and Oracle Database is not a user store and doesn't have such schema. Active Response doesn't seem correct as creating database connection for every request is expensive and a bad practise.
Any ideas would be appreciated.