JDBCRealm question

[Norris Shelton <no...@yahoo.com>]

We are authenticating internal users for authorization of the
Manager webapp.  Currently this uses a JDBC Realm.  The problem
is that the user account for each of our four environments has a
different password for security reasons.  We have a custom
object that can, given a schema name, look up the user
id/password for the environment you are in and return a DB
connection.

Is there someway to configure a realm to call a custom class to
get the DB connection?

Each webapp is configured as it's own service.  Per the docs, we
have a manager webapp context for each host.  Currently, all
look like:


<Context docBase="../../server/webapps/manager" path="/manager"
privileged="true">
    <Realm  className="org.apache.catalina.realm.JDBCRealm" 
               digest="MD5" 
           driverName="oracle.jdbc.driver.OracleDriver"         
                   
connectionURL="jdbc:oracle:thin:@server_name:1521:DEV01"
       connectionName="nunya" 
   connectionPassword="business"
            userTable="schema.table" 
          userNameCol="user_id" 
          userCredCol="password"
        userRoleTable="schema.table" 
          roleNameCol="role" />
<Valve className="org.apache.catalina.valves.RemoteAddrValve"
                              
allow="10.11.6.*,10.11.128.*,127.0.0.1"/>
                </Context>


=====

Norris Shelton
Software Engineer
Sun Certified Java 1.1 Programmer
Appriss, Inc.
ICQ# 26487421
AIM NorrisEShelton
YIM norrisshelton


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org