Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Section access and document CAL not working together

Hi all,

I've seen some questions about this around here but none quite helped me with my issue.

I have section access with both NTNAME and USERID/PASSWORD like this:

users:

LOAD * INLINE [

ACCESS, NTNAME, USERID, PASSWORD, OMIT

ADMIN, DOMAIN\QVAMIN, *, *

ADMIN, *, ADMIN, ADMIN

USER,*, USER1, USER1, EMPLOYEE_NAME

];

SECTION ACCESS;

SectionAccess:

LOAD * resident users;

SECTION APPLICATION;

I put a document CAL in this document in QMC (with dynamic CAL assignment). I run the task in QMC that loads the document, it runs fine, but when i try to access the document, it asks me for username and password, i input ADMIN/ADMIN and then i get the error of no CAL for this document.

Any ideas?...

Thanks!

Alex

Tags (2)
9 Replies

Re: Section access and document CAL not working together

Hi Alex, If you're using promted user for this access I think QV is checking the CALS assigned to the user wich has initiated the session in Operating System, not the one you're introducing.

Just guessing, not tested.

Not applicable

Re: Section access and document CAL not working together

Hi Ruben,

Thanks for your reply.

Not sure what you mean, though... In the task associated with the document my AD user, with which i'm logged in, has permission to access. The document has 3 allocated CALs with dynamic assignment.

Are you saying my AD user has to have a user name CAL ?...

Re: Section access and document CAL not working together

Can you post a screenshot of the QMC->User Documents->Your document->Document CALs tab for the document you are trying to open?

Not applicable

Re: Section access and document CAL not working together

Hi Peter, thanks for your help, is this what you meant?

CAL.png

manojkulkarni
Valued Contributor II

Re: Section access and document CAL not working together

did you tried with other users as well ? what is the result you are getting ?

Re: Section access and document CAL not working together

Are you sure that the QVS is (still) complaining about not having a CAL assigned to you? It seems like you do have one.

Maybe you enabled data reduction with strict exclusion and you are getting an "Access denied" message?

chrwolf64
Contributor III

Re: Section access and document CAL not working together

You can't merge NTNAME and USERID/PASSWORD in Section Access. Either NTNAME or USERID/PASSWORD, but not both, this doesn't work.

Not applicable

Re: Section access and document CAL not working together

Hi Christian,

According to several posts i read here, you can, for example

Section Access NTNAME or USERID

Section Access: Both USERID & NTNAME

Re: Section access and document CAL not working together

No, I wasn't saying that, but now that you mentioned it I'm not sure about it, In my understanding it should work with document CAL but you have one assigned... if you can do the quick test I'll try with an user license leased from server.

Another test, for something I readed.. can you try to use inline table in section acess instead of doing a resident load of users table?

And the last test will be removing NTNAME, to check if with only USERID and PASSWORD still says something about the CAL's.

Community Browser