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

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: David Lloyd Priority: Minor Fix For: jBPM jPDL 3.2 Original Estimate: 15 minutes Remaining Estimate: 15 minutes 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(a)sesamestreet.tv','cookie monster') INSERT INTO JBPM_ID_USER VALUES(2,'U','ernie','ernie(a)sesamestreet.tv','ernie') INSERT INTO JBPM_ID_USER VALUES(3,'U','bert','bert(a)sesamestreet.tv','bert') INSERT INTO JBPM_ID_USER VALUES(4,'U','grover','grover(a)sesamestreet.tv','grover') Fix: To allow Grover to login, this also needs INSERT INTO JBPM_ID_MEMBERSHIP VALUES(10,'M',NULL,NULL,4,4)