[jboss-user] [JBoss jBPM] - Re: jBPM Console - login failed

[rsdickerson]

I had to tweak the sql above a little bit for MS SQLServer. This worked for me.


SET IDENTITY_INSERT JBPM_ID_GROUP ON;
  | INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (1,'G','sales','organisation',NULL);
  | INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (2,'G','admin','security-role',NULL);
  | INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (3,'G','user','security-role',NULL);
  | INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (4,'G','hr','organisation',NULL);
  | INSERT INTO JBPM_ID_GROUP (ID_, CLASS_, NAME_, TYPE_, PARENT_ ) VALUES (5,'G','manager','security-role',NULL);
  | SET IDENTITY_INSERT JBPM_ID_GROUP OFF;
  | 
  | SET IDENTITY_INSERT JBPM_ID_USER ON;
  | INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (1,'U','user','user at sample.domain','user');
  | INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (2,'U','manager','manager at sample.domain','manager');
  | INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (3,'U','admin','admin at sample.domain','admin');
  | INSERT INTO JBPM_ID_USER (ID_, CLASS_, NAME_, EMAIL_, PASSWORD_ ) VALUES (4,'U','shipper','shipper at sample.domain','shipper');
  | SET IDENTITY_INSERT JBPM_ID_USER OFF;
  | 
  | SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP ON;
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (1,'M',NULL,NULL,2,4);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (2,'M',NULL,NULL,3,4);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (3,'M',NULL,NULL,4,4);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (4,'M',NULL,NULL,4,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (5,'M',NULL,NULL,1,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (6,'M',NULL,NULL,2,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (7,'M',NULL,NULL,3,3);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (8,'M',NULL,NULL,3,2);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (9,'M',NULL,NULL,2,2);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (10,'M',NULL,NULL,2,5);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (11,'M',NULL,'boss',2,1);
  | INSERT INTO JBPM_ID_MEMBERSHIP (ID_, CLASS_, NAME_, ROLE_, USER_, GROUP_ ) VALUES (12,'M',NULL,NULL,1,1);
  | SET IDENTITY_INSERT JBPM_ID_MEMBERSHIP OFF;
  | 

Scott

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134849#4134849

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134849