topic Re: Re: Re: Re: Re: Re: Help with Section Access in QlikView

Help with Section Access

hopkinsc — Fri, 30 Aug 2013 13:13:42 GMT

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

Re: Help with Section Access

jjordaan — Fri, 30 Aug 2013 13:28:09 GMT

Hi hopkinsc,

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

user: admin

PW: admin

Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 14:00:05 GMT

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?

Re: Help with Section Access

Bill_Britt — Fri, 30 Aug 2013 14:20:45 GMT

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

Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 14:37:12 GMT

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?

Re: Help with Section Access

jjordaan — Fri, 30 Aug 2013 14:58:28 GMT

Hi hopkinsc,

I made it work.

Check the attachment.

Re: Help with Section Access

Bill_Britt — Fri, 30 Aug 2013 15:07:29 GMT

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

Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:08:00 GMT

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..

Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:10:09 GMT

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

Re: Help with Section Access

jjordaan — Fri, 30 Aug 2013 15:10:17 GMT

That is strange.

It is working on my side

Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:13:26 GMT

hi Jeroen, yes i did. the one i uploaded has got my ntname in it..i just redownloaded it to check..

Re: Re: Re: Help with Section Access

jjordaan — Fri, 30 Aug 2013 15:18:55 GMT

Can you check the attachment again.

You have to change the NTNAme again to your own

Re: Re: Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:28:42 GMT

Hi Jeroen,

not sure what happened there but the copy i had did have my ntname in the script..

anyway, i have changed it again and uploaded a new copy and it still doesnt work. it lets me in now using my nt name, but it doesnt do any data reduction..

I should only be able to see RowSecLink 00400

Re: Re: Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:30:19 GMT

actually, it doesnt seem to be working at all. i have just changed mt NTNAME to something silly and it still let me in...

Re: Re: Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:35:20 GMT

Ok i know have it working

I had to change the section access part to..

PermissionTable:

NoConcatenate

LOAD

ACCESS,

USERID,

PASSWORD,

UPPER(NTNAME) as NTNAME,

UPPER(ROWSECLINK) as ROWSECLINK

Resident TempTable;

That now lets me in with data reduction..

Thanks for your help

Re: Re: Re: Re: Re: Help with Section Access

jjordaan — Fri, 30 Aug 2013 15:47:36 GMT

Can you check this one.

Re: Re: Re: Re: Re: Re: Help with Section Access

hopkinsc — Fri, 30 Aug 2013 15:56:13 GMT

Hi, no this didnt work again but if you rename the fields within the sectiojn access it works. see my attached file.

Thanks for your help