Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Section Access help

Hi everyone.

I am trying to set up section access, it works as expected if i open the document from the desktop client but it doesn't work on the server.

The server version is 11.0.11282.0

and the client version is  11.11414.0 SR2 64Bit

I have hardcoded 2 ADMIN logins in the Section Access inline load

Userid         Password

Admin         Admin

User1         User1

I have attached the files i am using, could somebody please take a look to see what i have wrong.

Thanks

Chris

10 Replies
Miguel_Angel_Baeyens

Hi Chris,

The issue is that the "*" does not mean "all possible values" rather than "all listed (specified) values in section access". In the field "Business Unit Code" that is present in the section access because of the JOIN, some users do not have any value, therefore they do not have access to the document. You either do the JOIN after concatenating both tables or even better, you load the first table without loading the bussiness unit code (note that names must be UPPERcase in section access).

Hope that helps.

Miguel

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi Miguel,

Thanks for the reply.

I don't understand though.

The section access works from the desktop client, I don't understand why the join would not work in the server?

Miguel_Angel_Baeyens

Chris,

The problem is not the JOIN, that will work in the Server as well. The issue is that in Desktop, either "*" or " " (blank) will grant you access to the application if you are an ADMIN or you don't have "Strict Exclusion" checked in your Document Properties, Opening tab.


But as a client you are always a USER, even if you hardcoded ADMIN in the ACCESS field in the section access table, therefore there are no valid "*" unless all values for that field have been specified beforehand.

Hope that makes sense.

Miguel

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi all, could anyone change the examples for me to see what is needed to be done to be fixed?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi Miguel,

I can see that you have renamed the field to uppercase and added the same field to the inline table.

Everything works from the QV client but NOTHING works from the server.

I am confused with the "*" values. do i need to change them in the spreadsheet? I thought having a "*" allows the user to see all values in the dataset? therefore when userid MLOM logs in, he\she would see access region B which means he/she will have access to 5 business unit codes?

And i know that section access is uppercase, but if the field itself is lowercase how would that work.

i.e. Business Unit code in the data is lower case so how would the UPPERCASE section access field link to it?

Thanks

Miguel_Angel_Baeyens

Hi Chris,

Yes, the "*" means that, at least one user (usually an ADMIN) must have one line for each field value.

Note that I changed uppercase the name of the field from the excel file as well. This model is actually working right in my computer desktop and server.

Hope that helps.

Miguel

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

ok thanks, i will try that. there was no excel file attached to your reply so i assumed it was left as is.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

hi miguel,

I now have it working on the server using the hardcoded userid's and the ones in the spreadsheet, but i cannot get the NTNAME to work.

and when i log in successfully (Using an id and password, and from the accesspoint on my local machine), if i type in a text box =osuser() the NTNAME of my server login appears not the NTNAME of my local machine.

Any ideas why that is happening?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Can anyone help with the NTNAME query please?