[jboss-jira] [JBoss JIRA] Created: (JBPM-888) jBPM Suite web-console: user grover cannot login

[Arjan van Bentem (JIRA)]

jBPM Suite web-console: user grover cannot login
------------------------------------------------

                 Key: JBPM-888
                 URL: http://jira.jboss.com/jira/browse/JBPM-888
             Project: JBoss jBPM
          Issue Type: Bug
          Components: Web Interface
    Affects Versions: jBPM jPDL 3.2 beta 2
         Environment: All
            Reporter: Arjan van Bentem
         Assigned To: Tom Baeyens
            Priority: Minor


The demo user "grover" cannot log into the web console.

The file \jbpm-jpdl-3.2.Beta2-suite\server\server\jbpm\data\hypersonic\jbpmDB.script holds, among many other lines:

INSERT INTO JBPM_ID_MEMBERSHIP VALUES(1,'M',NULL,NULL,2,2)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(2,'M',NULL,NULL,2,4)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(3,'M',NULL,NULL,1,4)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(4,'M',NULL,NULL,3,4)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(5,'M',NULL,NULL,3,3)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(6,'M',NULL,NULL,2,3)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(7,'M',NULL,NULL,2,5)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(8,'M',NULL,'boss',2,1)
INSERT INTO JBPM_ID_MEMBERSHIP VALUES(9,'M',NULL,NULL,1,1)
INSERT INTO JBPM_ID_USER VALUES(1,'U','cookie monster','cookie.monster at sesamestreet.tv','cookie monster')
INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','ernie at sesamestreet.tv','ernie')
INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','bert at sesamestreet.tv','bert')
INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','grover at sesamestreet.tv','grover')

Fix:

To allow Grover to login, this also needs

INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,NULL,4,4)


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira