5 Replies Latest reply: Dec 14, 2011 10:14 AM by Richard Pearce RSS

    Section Access using a QVD file with a combination of userID, password and NTName

      Hi,

       

      I've having some problems with Section Access which works fine if I use a excel workbook or inline load as the data source but when using a QVD file it doesn't want to play.

       

      I'm using a combination of USERID, PASSWORD & NTNAME and my qvd file looks like this:

       

      USERID PASSWORD NTNAME ACCESS GROUPSECURITYLINK
      ADMIN ADMIN * ADMIN
      CALLCENTRE\RICHARD.PEARCE ADMIN

       

      This is the script which generates it:

      TeamLeader_SectionAccess:
      LOAD * Inline [
      USERID, PASSWORD, NTNAME, ACCESS, GROUPSECURITYLINK
      ADMIN, ADMIN, *, ADMIN,
      ,,CALLCENTRE\RICHARD.PEARCE,ADMIN,

      ];

       

      Store TeamLeader_SectionAccess into TeamLeader_SectionAccess.qvd (qvd);

       

      Here is my QVW import script:

      SET NullInterpret=''; // <<< --- Only required if bringing information back from tables (not databases).

      SECTION Access;

      LOAD USERID,
           PASSWORD,
           NTNAME,
           ACCESS,
           GROUPSECURITYLINK
      FROM [TeamLeader_SectionAccess.qvd] (qvd)
      where 1=1;

       

      This works fine if I either use just the USERID and PASSWORD fields and comment out NTNAME

      This also works the other way around, when I remove the USERID and PASSWORD

       

      The probem is when I leave them both in, I should be able to log straight in (as it's my NTNAME) although it still works when i type admin/admin

       

      Can anyone help as I've been suffering since yesterday morning on this problem?

       

      Thanks in advance

       

      Richard

       

       

      I've attached the files I'm working with.....