Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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

9 Replies
rubenmarin

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
Author

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Author

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

CAL.png

manojkulkarni
Partner - Specialist II
Partner - Specialist II

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

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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?

cwolf
Creator III
Creator III

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
Author

Hi Christian,

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

Section Access NTNAME or USERID

Section Access: Both USERID & NTNAME

rubenmarin

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.