2 Replies Latest reply: Mar 18, 2013 1:19 PM by dh_madhu RSS

    Reloading the script overrides section access rules...

      Hi all

      This is my first post...apologies if this topic has been discussed.

      If already there, any link to it would suffice...else here's my issue...

       

      I have created a section access something like this:

       

       

      Section Access;

      LOAD * INLINE [

          ACCESS, USERID, PASSWORD, NTNAME, NTDOMAINSID,PVCA_DWH_STUDY_ID

          ADMIN, ADMIN, ADMIN, *, *,*

          USER, USER1, USER1, *, *,-2

          USER, USER2, USER2, *, *,-1

      ];

       

       

       

       

      Now, 

      I save as a new *.qvw file and when I reopen the report with different user id's ...it works fne.

      when I login as a USER1 it shows me only the -2's BUT when I do a "Reload" script ...its prompts me to "save as" ...and here if I "cancel" the operation

      ALL the data gets loaded into the report thereby overriding the section access privileges.

      Cant understand where am going wrong...Any idea??

      Thanks

      Madhu