Symantec Access Management

  • 1.  Sending data from Oracle DB in Response

    Posted Mar 03, 2016 11:28 AM

    Hello,

     

    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.

     

    Best Regards



  • 2.  Re: Sending data from Oracle DB in Response

    Posted Mar 07, 2016 05:37 AM

    I don't see any option other than the active response.

    Oracle db is neither user store or nor any other siteminder manged db, so obviously it will not have any logic do the connection pooling for this special purpose database.