glassfish
  1. glassfish
  2. GLASSFISH-3023

JDBCRealm should support different table structures

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 9.1pe
    • Fix Version/s: not determined
    • Component/s: security
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: Linux

    • Issuezilla Id:
      3,023

      Description

      In SJSAS 9.0 I used net.java.glassfish.security.auth.realm.jdbc.JDBCRealm for
      authentication as it supports the following use properties:

      find-user-query
      find-groups-query

      It's useful because my databases use many-to-many relationships for users and
      usergroups, i.e.:

      SELECT id FROM user WHERE email = ? AND password = ?

      SELECT usergroup.name FROM user, usergroup, user_usergroup WHERE user.email = ?
      AND user_usergroup.user
      _id = user.id AND user_usergroup.usergroup_id = usergroup.id

      Those properties allowed me to use the above queries to define how user
      names/passwords and user group names should be checked.

      Can these properties be added to
      com.sun.enterprise.security.auth.login.JDBCLoginModule ? Looking at the source
      for JDBCLoginModule it would be a fairly simple extension.

      In 9.1 using net.java.glassfish.security.auth.realm.jdbc.JDBCRealm has become
      more difficult as com.sun.gjc.spi.DataSource for which it needs to function are
      no longer packaged in $

      {com.sun.aas.installRoot}

      /lib/appserv-rt.jar

      Thanks

      Dan

        Activity

        danielrhoades created issue -
        kenaiadmin made changes -
        Field Original Value New Value
        issue.field.bugzillaimportkey 3023 34627
        Tom Mueller made changes -
        Fix Version/s not determined [ 11149 ]
        Fix Version/s 9.1pe [ 10974 ]

          People

          • Assignee:
            raharsha
            Reporter:
            danielrhoades
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: