3 Replies Latest reply: May 24, 2013 4:26 AM by Thomas Jensen RSS

    Section access based on Section Application

      Hello,

       

      How come this does not work?

       

      Section Access;

      LOAD * INLINE [

          ACCESS, USERID, PASSWORD

          ADMIN, ADMIN, ADMIN

          USER, Hans, DuEr1

          USER, Kent, DuEr2

          USER, Olga, DuEr3

      ];

      Section Application;

       

       

      LOAD * Inline [

       

      USERID, CustomerID

      Hans, UHMD

       

       

      ];

       

      I want the user hans only able to see CustomerID UHMD (its a string)

       

      I have this table in my edit script

      QUALIFY*;

      UNQUALIFY CustomerKey;

      DimCustomer:

      LOAD CustomerKey,

          PartnerID,

          CustomerID,

          PartnerKey,

          LaCustomerKey;

      SQL SELECT *

      FROM DW.dbo.DimCustomer;

      UNQUALIFY*;

       

       

       

      When i try to go into my qvw doucment i get access denied, except on admin level, i am allowed to go to my qvw file.