BProc userRole RoleName

Support
#1

Hi,

when I create a new role which I want to use in BProc,
following the examples of how to select users for specific tasks in the BProc model,
I see an issue.
Creating the role, the column ROLE_NAME is not populated in sec_user_role.
So, when running this SQL:
select u from sec$User u join u.userRoles ur where ur.roleName = :roleName
it will never have a result set (only when I filter on NULL).

Next, when I use the Entity_Manager, I can manually type in a ROLE_NAME and save it.
Then the SQL works.

But, doing that, the role which I assigned to the user under Administration User is no longer
shown in the role list (but still existing).

So,
how to explain this?

Kind Regards
Roland

#2

Hi,
UserRole entity has two fields that reference the role - it’s Role role and String roleName.
Role role field stores a reference to the database role entity. The String roleName field was introduced for design-time roles only. So each UserRole record has either role or roleName fields field. You should analyze both these fields.

1 Like
#4

thx, will do that…