Web Services : AD_User_OrgAccess table is not used on login

Activity

Show:
Nicolas Micoud
April 9, 2020, 5:45 AM

Hello,

Attached a patch with a new query for CompiereService.checkLogin method (also converted from String to StringBuilder).
I think the query is ok, but something else need to be changed because when the role is IsUseUserOrgAccess=Y (and orgs defined at user level), I got those warnings in log :

07:29:32.174===========> MRole.getClientWhere: No Access Org records [223]
07:29:32.195===========> MRole.getOrgWhere: No Access Org records [223]

And I cannot find the reason

I also join the WS I'm using and the request.

Steps to reproduce :

If the GW / Web Service Execution role is :

  • IsAccessAllOrgs = Y => OK

  • IsUseUserOrgAccess = N (and org(s) defined on the role) => OK

  • IsUseUserOrgAccess = Y (and org(s) defined on the user) => KO (No Access Org records)


Any idea where to look ?

Thanks,

Nicolas

Carlos Ruiz
April 11, 2020, 1:22 PM

, worked fine in my tests - I found similar issue, but was wrong definition on my side (org=0, warehouse<>0)

Assignee

Nicolas Micoud

Reporter

Nicolas Micoud

Labels

None

Tested By

None

Components

Priority

Major
Configure