Section Access help

[hopkinsc]

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

[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]

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]

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

[hopkinsc]

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]

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

[hopkinsc]

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]

Can anyone help with the NTNAME query please?