topic user access control appears to fail in QlikView https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148918#M716766 <HTML><HEAD></HEAD><BODY><P>Has anyone an idea why my code does not work? I never got a reply.</P></BODY></HTML> Tue, 25 Aug 2009 21:16:55 GMT 2009-08-25T21:16:55Z user access control appears to fail https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148916#M716764 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am trying to set up a fine grained access control system for a QlikView application, using QV 8.5.</P><P>Here is a stripped down prototype (see attachment). It has two dimensions, Product and Channel, and one measure, Turnover. Access is based on ACLs that can be assigned to individual users.</P><P>In the example</P><UL><LI>user becker is supposed to be the app admin, with access to everything (ACL=BACKSTAGE)</LI><LI>user x is supposed to see all products for channel 1, and additionally all channels for product 1 (ACL=ACLx)</LI><LI>user z is supposed to see only the combination (product 2, channel 2) (ACL=ACLz)</LI></UL><P>Without access control, placing a selection on any one of the ACL items works exactly as expected.</P><P>When I open the application with access control enabled:</P><UL><LI>User becker can log in and can edit the script, but cannot view any numbers</LI><LI>Users x and z cannot even log in!</LI></UL><P>To reproduce the failure, open the application and uncomment the "SECTION application" directive in the Users tab in the script (tab 2), then re-run the script.</P><P></P><P></P></BODY></HTML> Thu, 09 Jul 2009 20:23:04 GMT https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148916#M716764 2009-07-09T20:23:04Z user access control appears to fail https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148917#M716765 <HTML><HEAD></HEAD><BODY><P>Sorry, of course it had to be:</P><P>uncomment the "SECTION <B>access</B>" directive in the Users tab in the script (tab 2), then re-run the script.</P><P></P></BODY></HTML> Thu, 09 Jul 2009 20:32:19 GMT https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148917#M716765 2009-07-09T20:32:19Z user access control appears to fail https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148918#M716766 <HTML><HEAD></HEAD><BODY><P>Has anyone an idea why my code does not work? I never got a reply.</P></BODY></HTML> Tue, 25 Aug 2009 21:16:55 GMT https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148918#M716766 2009-08-25T21:16:55Z user access control appears to fail https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148919#M716767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I don't know exactly why Qlikview can't join the combination uppercase and lowercase at the value 'ACLx' of the Dim_Credentials table with the ACLs_raw table, I think the "section access" changes all the values to uppercase, for this reason, the user becker can access because its filter value is BACKSTAGE (uppercase).</P><P>I've attached your file with the modifications and it works.</P><P>I hope this will help you.</P><P></P></BODY></HTML> Thu, 27 Aug 2009 18:08:51 GMT https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148919#M716767 2009-08-27T18:08:51Z user access control appears to fail https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148920#M716768 <HTML><HEAD></HEAD><BODY><P>Thanks Magv, that did it!</P></BODY></HTML> Thu, 27 Aug 2009 18:31:37 GMT https://community.qlik.com/t5/QlikView/user-access-control-appears-to-fail/m-p/148920#M716768 2009-08-27T18:31:37Z