Team,
We have a below requirement.
1. We have a CA Directory user store that we have configured in siteminder for authorization purpose.
2. We are sending the responses to the application once the user is authorized based on the conditions specified in domain policy, users tab.
3. In responses, we are sending the user profile attributes (such as roles, first name, last name etc.).
4. In addition to that, we have a new requirement to send a response (from SQL database) to the application. In this, we need to run a query based on a particular roles to fetch the business functions associated with those roles. We then need to send those business functions to the application as a response.
Solution: We are currently exploring the options. One thought i had in mind is, we can define a variable definition to fetch the value from the SQL database based on SQL query and then send a response to the application team.
Other thought was using sql query schemes, I am not sure whether how we can use SQL query schemes to handle this scenario.
If nothing above is possible, we can anytime go for a active response to fetch the value from SQL database and send it as a response to the application team.
Any suggestions or assistance around the approach to acheive this will be really helpful.
Thanks,
Shivam