how to make JDBCRealm to check role only.

Posted on 2006-03-22
Last Modified: 2010-04-01
I posted the same question at web server section but no answer so far :( figure I try it here.

<Realm className="org.apache.catalina.realm.JDBCRealm" driverName="" connectionURL="jdbc:mysql://localhost/authority" connectionName="test" connectionPassword="test" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" />

Above is the typical Realm tag in Tomcat, as you can see it uses to verify user name, password and user roles.  However, I have tomcat working with IIS and IIS took care of checking the NT user name and password, is there a way I can use JDBCRealm to just verify the role only?
Question by:fylix0000
    LVL 29

    Expert Comment

    Are you looking to implement single sign-on with Windows and Tomcat?

    Author Comment

    I'm using IIS to check the user name and password, which is basdically user's NT log on.  Once IIS "authenticate" this, tomcat will use the JDBCRealm to  "authorize" if  this NT user name has the correct role before it let the user in.  

    Right now, the above Realm setup make Tomcat does both authentication and authorization process.

    I albe to get IIS to check the user name and password but I do not know how to make Tomcat to check just the role only.
    LVL 29

    Accepted Solution

    So it is single sign on to tomcat using the Windows credentials...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    decryption not working 5 73
    library class in java 1 88
    Fisheye tool 2 96
    JSONSerializer.toJSON in JSP generating error 8 47
    After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneous…
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now