Couldn't you write the sql statement such that it takes all of that into account? Your may need to switch your mode of db authn for that.
> From: "Snoke, Nancy" <[email protected]> > To: [email protected] > Sent: Wednesday, October 18, 2017 7:20:10 AM > Subject: [cas-user] multiple jdbc authenticatioon handlers to same db > SO this seems like a really silly way to do this, and I was wondering if I was > missing anything obvious. > We allow users to login with email and password and account number and > password > as well as user id and password. It’s the same database and same password each > time, just three options ofr the username. > It seems like I have to create a separate query auth handler with all > connection > details for each login, when the only difference is the sql. Is there anyway > to > point to the same datasource for all 3? Or is having the datasource details in > my config 3 times the way to do it? > Thanks, > Nancy > CONFIDENTIALITY NOTICE: This e-mail, including any attachments, may contain > confidential, privileged and/or proprietary information which is solely for > the > use of the intended recipient(s). Any review, use, disclosure or retention by > others is strictly prohibited. If you are not an intended recipient, please > contact the sender and delete this e-mail, any attachments and all copies. > Permanent General Assurance Corporation | Permanent General Assurance > Corporation of Ohio | The General Automobile Insurance Company, Inc. | Home > Office: 2636 Elm Hill Pike, Nashville, TN 37214 > -- > - Website: https://apereo.github.io/cas > - Gitter Chatroom: https://gitter.im/apereo/cas > - List Guidelines: https://goo.gl/1VRrw7 > - Contributions: https://goo.gl/mh7qDG > --- > You received this message because you are subscribed to the Google Groups "CAS > Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email > to [email protected] . > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/9ee8fe917f764986a512501ed232db0e%40TGI-EX13MBX01.pgac.com > . -- --Misagh -- - Website: https://apereo.github.io/cas - Gitter Chatroom: https://gitter.im/apereo/cas - List Guidelines: https://goo.gl/1VRrw7 - Contributions: https://goo.gl/mh7qDG --- You received this message because you are subscribed to the Google Groups "CAS Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/cas-user/1836720218.5604258.1508350598799.JavaMail.zimbra%40unicon.net.
