One of the Oracle based sources we are publishing is using Oracle context variables to enable Oracle's fine grained access control. So we are in the need to set these context variables (e.g. current username) prior to doing the select defined by MapServer's DATA statement. In other applications we do that by calling a set_context (...) stored procedure prior to any data requests. Is there any possibility in MapServer to send a pre-request statement to the database? A current work-around is to set the context at logon time but that means that we need a new logon for every request that needs a different user context, not optimal for websites with many users. We'd prefer to have a single logon that can be re-used for all requests. If there is currently no way to handle this in MapServer we'd like to extend the Oracle layer's capabilities. Any suggestion by the MS developers on where we should place the needed extension in the mapfile (e.g. adding an additional keyword at the USING part of the data statement or using new layer metadata)? Any interest in generalizing this approach?
Tx Martin -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-Layer-how-to-set-context-prior-to-fetching-the-data-tp5258155.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
