Help with Section Access

[hopkinsc]

Hi All,

I am trying to get section access working with NTNAMES. it works when entering UserID and PW but i cant seem to get it to work using NTNAMES.

can anyone see if i am doing anything wrong please?

I have attached the files needed.

The User ID's/passwords are

admin, admin

user1, user

Many thanks

[jjordaan]

Hi hopkinsc,

Loop at the created attachment. Maybe it can help you.

user: admin

PW: admin

[hopkinsc]

Thanks for your reply. it seems to work with your sample, but you asre just using a simple inline load whereas i am using a load from QVD with the inline load concatenated to it then a resident load within the section access part.

i am confused on what i am doing wrong?

can anyone help please?

[Bill_Britt]

I would go back and start over and do a little at a time till you find out what broke it. That may be the only want to figure out what is happening.

Bill

[hopkinsc]

Hi Bill,

I just tried doing the inline load in the section access part instead of the resident load and commented out the standard load i did at the beginning of the script and this works.

The reason i used a resident load within the section access/section application part was because for some reason i cant put the qvd load in that section as i get field not found for all of my fields.

So this is how i first tried (which gives me fields not found on the first qvd load)

SECTION ACCESS;

LOAD

  Upper([User ID]) as NTNAME,

     UPPER(RowSecLink)as ROWSECLINK,

     'USER' as ACCESS,

     '*' as USERID,

     '*' as PASSWORD

FROM

SectionAccess.qvd

(qvd) where 1=1;

concatenate

LOAD * INLINE [

  ACCESS, USERID, PASSWORD, NTNAME, ROWSECLINK

  ADMIN, ADMIN, ADMIN, *, *

  USER, USER1, USER, *, 00380

  USER, *, *, CHRISHOPKINS-PC\Chris Hopkins,00400

];

SECTION APPLICATION;

STAR is *;

SecurityLinkTable:

LOAD RowSecLink as ROWSECLINK,

     [Business Unit]

FROM

DataReductionLink.qvd

(qvd);

because of the fields not found issue i then tried this (as per my example attached to my original question..

[Section Access]:

LOAD

  Upper([User ID]) as NTNAME,

     UPPER(RowSecLink)as ROWSECLINK,

     'USER' as ACCESS,

     '*' as USERID,

     '*' as PASSWORD

FROM

SectionAccess.qvd

(qvd) where 1=1;

Concatenate ([Section Access])

LOAD * INLINE [

  ACCESS, USERID, PASSWORD, NTNAME, ROWSECLINK

  ADMIN, ADMIN, ADMIN, *, *

  USER, USER1, USER, *, 00380

  USER, *, *, CHRISHOPKINS-PC\Chris Hopkins,00400

];

SECTION ACCESS;

Load *

Resident [Section Access];

SECTION APPLICATION;

STAR is *;

SecurityLinkTable:

LOAD RowSecLink as ROWSECLINK,

     [Business Unit]

FROM

DataReductionLink.qvd

(qvd);

This worked for the hardcoded userid's but not for ntname.

Next i tried removing the section access qvd load comnpletely and put the inline load within the

section access/section application part which worked as expected.

I dont know what i am doing wrong.. is it an issue with doing a resident load within section access.section application?

[jjordaan]

Hi hopkinsc,

I made it work.

Check the attachment.

[Bill_Britt]

Hi Jeroen,

That is what I was going to try and do, because I really didn't like the table being call [section access]. This should work for Hopkinsc.

Bill

[hopkinsc]

Hi JJ,

Thanks for your reply although it still isnt working.. it still prompts me for a user id. and now when i enter User1 it shows me everything whereas user1 should only see RowSecLink 00380

i have reattached your qvw with the changes i made for my ntname and i uncommented Section Access / Section Application..

[hopkinsc]

hi Bill, is Jeroen's version working for you?

[jjordaan]

That is strange.

It is working on my side