0 Replies Latest reply: Jun 20, 2018 9:47 AM by Amir Mohamed RSS

    Sheet level access to specific stream only

    Amir Mohamed

      HI all,

       

      I have looked at this video, Qlik Sense Stream Management  Security Rules and Exception Management - YouTube and at this page Sheet or App Object Level Security Qlik Sense but I am unable to get what I want,

       

      What I am trying to do is ; example

      I have 2 users, that have access to 5 streams with its apps and sheets, but there is 1 stream (Sales which has 1 app and 5 sheets) that I want User 1 to have access to 3 sheets and  User 2 to have access to 3 other sheets

      sheet names;

      1 Sales summary

      2 CS

      3 Budget

      4 Service

      5 CustomReport

       

      User 1 has access to sheets (1,2,3) user 2 has access to (1,4,5)

      I have tried following the links above but I don't get it right it either removes access from both users/ and their other streams or it give access to all.

       

      I don't want the other streams to be affected.

      the security I am using is

      (resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read")

      and ((resource.name!="Budget" or resource.name!="CS") or user.name="User 2")

      and ((resource.name!="Service" or resource.name!="CustomReport") or user.name="User 1")

      )


      Would you please be able to help

       

      Many thanks,