Currently we are using a connection pool (via BEA app server) to access our Oracle database. However, for security purposes, we are going to incorporate OLS. This basically means instead of executing each query (insert/update/delete) as the default user/pwd for the connection (from the connection pool), we now need to execute those queries as a specified user. Additionally we would like to still use the connection pool. Thus creating a connection per user/pwd contradicts the whole reason behind the connection pool: connections are expensive to create.
Does anyone have experience to share or direction to go research?
We are also looking for a similar solution. But no luck with weblogic connection pool. What we are experimenting is writing a proxy to our DAO's so that once we get a DB connection from the pool then apply OLS label using proxy. But this has server performance impact especially in enterprise scale app. Honestly speeking we don't know any other solution and we are still struggling to come-up with a neater solution.
We are hoping Oracle will look into our request and provide elegent solution. In the mean time if any of you find or have any suggestion please share your ideas. Thanks