Fixed
Details
Assignee
Carlos RuizCarlos RuizReporter
Norbert BedeNorbert BedePriority
Major
Details
Details
Assignee
Carlos Ruiz
Carlos RuizReporter
Norbert Bede
Norbert BedePriority
Created April 19, 2015 at 6:18 AM
Updated June 1, 2015 at 3:50 PM
Resolved April 21, 2015 at 5:23 PM
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