-
1. Re: JBPM Data Base - Table's column meaning
kukeltje Apr 1, 2009 9:09 AM (in response to zuipli)the .CLASS_ things have to do with hibernate and inheritance. Look at the
hibernate mappings."check the article in the Wiki" is not very useful.
I disagree, since (at least) I only say this when there IS an article about it in the wiki or the forum. I think I do not *have* to search for you do I... there are things you can do yourself and learn from it... just the way I and others did. e.g. often when searching you see things that can come in handy later on. -
2. Re: JBPM Data Base - Table's column meaning
zuipli Apr 1, 2009 11:41 AM (in response to zuipli)Ok, thank you for your answer. Anyway I'm not able to understand what Group Type means.
Using the scripts found in the Wiki I have created the base configuration on my MySQL JBpm Data Base.
I logged in as "manager" and in the Identities link I have added a new Group called "baseusers". In this moment there is the possibility to specify the Group Type. But which values are availables? (it's the same question of my previous post), so I have left this field blank. Then I have created a new user called Stefano and I have added a Membership to this user with the "baseusers" group.
With this new user I'm not able to login. Why? I get
HTTP Status 403 - Access to the requested resource has been denied
If I don't use my Group (baseusers) I'm able to login using Stefano just if I add membership with all the existing pre-defined groups
- admin
- sales
- manager
- hr
- sales
Sorry kukeltje, I know that I'm a complete newbie but for me it's very difficult to understand how Jbpm works about this configuration. -
3. Re: JBPM Data Base - Table's column meaning
zuipli Apr 1, 2009 12:51 PM (in response to zuipli)An example: in this moment I added to my user Stefano the membership in groups hr, admin and user, the same groups of the admin user, and to do this I used the jbpm-console.
Why using Stefano I'm not able to login in the jbpm-console?
In the jbpm data base this are the values:
select t1.id_, t1.name_, t1.password_,
t3.name_ as group_name, t3.type_ as group_type
from jbpm_id_user t1,
jbpm_id_membership t2,
jbpm_id_group t3
where t1.id_ = t2.user_ and
t2.group_ = t3.id_ and
t1.name_ in ('admin', 'stefano');
order by t1.id_, t3.name_;
id_name_password_group_namegroup_type
3adminadminadminsecurity-role
3adminadminhrorganisation
3adminadminusersecurity-role
104stefanostefanoadminsecurity-role
104stefanostefanohrorganisation
104stefanostefanousersecurity-role -
4. Re: JBPM Data Base - Table's column meaning
zuipli Apr 2, 2009 11:05 AM (in response to zuipli)Please kukeltje ....