Section Access Query.

[MuraliPrasath]

Hi QV Team,

I've to appy Section Access on my Application based on NT Login.

I've created a hidden script and used following script.

************************************

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    USER, TXT/AAndrade

    USER, TIC/AParonica

    USER, TXT/gbagby

    ADMIN, TXT/sbaggiano

    ADMIN, TXT/jbarrett

   ];

Section Application;

LOAD ACCESS,

     NTNAME,

     EmailID,

     Sales_Representative

FROM

[..\..\Data\FlatFiles\ABC_SectionAccess_userextract.xls]

(biff, embedded labels, table is ABC_SectionAccess_userextra$);

***************************************

After doing this, i can't able to open the document anymore.

It says "Access denied".

My requirement is to reduce the fields based on the user login(NT Login)

Please some one suggest me some thing.

[PrashantSangle]

Hi,

try NTNAME list in capital latter.

Regards

[qlikviewwizard]

Hi murali69

Section works on case sensitive and should use capital letters.

[jonathandienst]

Section Access;

LOAD ACCESS,

  Upper(NTNAME) As NTNAME

INLINE [

    ACCESS, NTNAME

    USER, TXT/AAndrade

    USER, TIC/AParonica

    USER, TXT/gbagby

    ADMIN, TXT/sbaggiano

    ADMIN, TXT/jbarrett

   ];

[sujeetsingh]

Follow the thread

Section Access using NTName Issue

[MuraliPrasath]

Hi,

I followed this method but still I'm facing the same issue. After following this I'm unable to open the document.

" Access Denied to this document".

[nagarjuna_kotha]

Check this :

Section Access using NTName Issue

[PrashantSangle]

Hi,

You are login with which userName???

Regards

[qlikviewwizard]

Did your NT USERNAME details added into the script?

We should add.

Are you opening this in personal edition?

If yes,

Did you lease the license from the server?

[#10]

One trick that might help you to find a solution could be to create a text-box and add =osuser() to make sure the username that QV fetches looks the same as the ones in your list.