3 Replies Latest reply on Jan 4, 2009 1:52 PM by kukeltje

    DatabaseServerLoginModule question

    jeremiah.lumontod

      i have the following tables:

      jbmp_id_group

      1 G sales organisation
      2 G manager security-role
      3 G hr organisation
      4 G admin security-role
      5 G user security-role
      6 G support security-role
      7 G talentscout security-role
      8 G legaladviser security-role
      9 G bandmember security-role
      10 G recordproducer security-role
      11 G artistdevelopment security-role
      12 G songwriter security-role
      13 G musician security-role
      14 G videoproduction security-role
      15 G artist security-role
      16 G administrator security-role
      17 G manager security-role
      18 G participant security-role
      19 G administrator security-role


      jbmp_id_user


      1 U user powellb@bland.com powellb
      2 U manager rumpoleh@bland.com rumpoleh
      3 U admin memberb@bland.com memberb
      4 U shipper dredr@bland.com dredr
      5 U support dredr@bland.com support
      101 U powellb powellb@bland.com powellb
      102 U rumpoleh rumpoleh@bland.com rumpoleh
      103 U memberb memberb@bland.com memberb
      104 U dredr dredr@bland.com dredr
      105 U harrisr harrisr@bland.com harrisr
      106 U lennonj lennonj@bland.com lennonj
      107 U hendrixj hendrixj@bland.com hendrixj
      108 U welleso welleso@bland.com welleso
      109 U monetc monetc@bland.com monetc
      110 U admin admin@bland.com admin
      111 U manager manager@bland.com manager


      jbmp_id_membership


      52 M 1 1
      45 M 1 5
      51 M 2 1
      41 M 2 2
      50 M 2 3
      42 M 2 4
      44 M 2 5
      49 M 3 3
      43 M 3 4
      48 M 3 5
      46 M 4 3
      47 M 4 5
      53 M 5 1
      54 M 5 2
      55 M 5 3
      56 M 5 4
      57 M 5 5
      72 M 101 15
      58 M 101 16
      73 M 102 15
      59 M 102 16
      74 M 103 15
      60 M 103 16
      75 M 104 15
      61 M 104 16
      76 M 105 15
      62 M 105 16
      77 M 106 15
      63 M 106 16
      78 M 107 15
      64 M 107 16
      79 M 108 15
      65 M 108 16
      80 M 109 15
      66 M 109 16
      71 M 110 15
      69 M 110 16
      67 M 110 16
      70 M 111 15
      68 M 111 16



      userid 1 to 5 can login, the rest cant in jboss 4.2.2 jbpm-3.3.0 mysql. please someone tell me why?





        • 1. Re: DatabaseServerLoginModule question
          kukeltje

          yes, because they do not have the security-role of user

          • 2. Re: DatabaseServerLoginModule question
            jeremiah.lumontod


            thanks ronald. here's what i did in my web.xml:



            <security-constraint>
            <web-resource-collection>
            <web-resource-name>Secure Area</web-resource-name>
            <url-pattern>/sa/*</url-pattern>
            <http-method>GET</http-method>
            <http-method>POST</http-method>
            </web-resource-collection>
            <auth-constraint>
            <role-name>admin</role-name>
            <role-name>user</role-name>
            <role-name>manager</role-name>
            <role-name>hr</role-name>
            <role-name>sales</role-name>
            <role-name>support</role-name>
            <role-name>it</role-name>
            <role-name>Talent scout</role-name>
            <role-name>Legal adviser</role-name>
            <role-name>Band member</role-name>
            <role-name>Record producer</role-name>
            <role-name>Artist development</role-name>
            <role-name>Songwriter</role-name>
            <role-name>Musician</role-name>
            <role-name>Video production</role-name>
            <role-name>Artist</role-name>
            <role-name>Administrator</role-name>
            <role-name>participant</role-name>
            </auth-constraint>
            </security-constraint>






            • 3. Re: DatabaseServerLoginModule question
              kukeltje

              security-role of user in the database