Can't login by SuperUser to client with client roles has "Use User Org Access"

Description

IRC chat 17.5.2015

Problem:
in adempiere superuser was able to login to any client
18:00 and in regular client was SuperUser visible well
18:00 now i found in app dict. User/User tab sql: (AD_User.AD_Client_ID=@#AD_Client_ID@)
18:01 means superuser is not visible for regular client users
18:01 meanwhile i change role strategy for a client - where orgs will be assigned by users/org tab
18:02 at the end i found an issue, where with roles inherits master roles from system cant login to regular client
18:03 i mean when i create a regular role with windows etc. then superuser able to login. but with role consist from included roles cant login with superuser

CarlosRuiz Solution
20:01 I just unchecked the "Use User Org Access" - and immediately it appears in the list
20:02 so, confirmed that's the cause
20:02 now for the solution
20:06 ok - I needed to change three things
20:06 1 - clear the where clause on the User tab
20:07 2 - change the default on column AD_User_OrgAccess.AD_Client_ID to @#AD_Client_ID@
20:07 3 - change the default on column AD_User_OrgAccess.AD_Org_ID to @#AD_Org_ID@
20:07 and now you can assign GW orgs to SuperUser
20:08 maybe that deserves a JIRA ticket with that migration script

The solution working well, tested in my local database

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Priority

Created April 19, 2015 at 6:18 AM
Updated June 1, 2015 at 3:50 PM
Resolved April 21, 2015 at 5:23 PM