Restrict access to connection pool in Weblogic?
Posted
by Andrew White
on Stack Overflow
See other posts from Stack Overflow
or by Andrew White
Published on 2010-02-22T16:28:18Z
Indexed on
2010/03/27
5:03 UTC
Read the original article
Hit count: 386
In short, how can I restrict access to connection pool X based on application name or JAR name? A simple use case might help...
A business web-app (call it WEB_APP_A) uses pool Y to do basic look-up SQL. Some users of this web-app have access to also update some sensitive data in the database. This code is provided by a JAR file (call it HR_JAR) that can be dropped in where needed. This JAR uses pool X for all of it's connections.
We don't want developers of WEB_APP_A using pool X. We only want HR_JAR using pool X. This is to keep devs of WEB_APP_A from accidentally or intentionally abusing the access pool X provides.
Some considerations:
- This is legacy code so HR_JAR is here to stay
- We are running on Weblogic 9.2
- We can not keep passwords in any from in the source code
- We have researched weblogic user level authn/authz for JDBC resources but then this begs the question; how do we secure the user creds we use to become a user per app/jar?
Ideas? Thoughts? I can elaborate more on what I have tried, but I wanted fresh ideas.
© Stack Overflow or respective owner