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

Status

Assignee

Carlos Ruiz

Reporter

Norbert Bede

Labels

None

Tested By

None

Priority

Major
Configure