topic Re: Section Access - Access Point Issue in QlikView

Section Access - Access Point Issue

sridhar_sigired — Fri, 05 Feb 2016 10:07:29 GMT

Hi,

I have implemented below section access and working fine with desktop version.

ACCESS	NTNAME	NTDOMAINSID	REGION
ADMIN	AGDT\ADMINISTRATOR	B-16-5-21-464368543-689502253-265866
ADMIN	AGDT\USER1	B-16-5-21-464368543-689502253-265866	SOUTH
USER	AGDT\USER2	B-16-5-21-464368543-689502253-265866	NORTH
USER	AGDT\USER3	B-16-5-21-464368543-689502253-265866	EAST
USER	AGDT\USER4	B-16-5-21-464368543-689502253-265866	WEST

It is running properly in QMC also. After running it, i am unable to open it in access point. While opening it in access point, it is asking for credentials. Entering with user "AGDT\USER1" and window password. But these are not working.

Is there any issue with QMC (11.2 SR8) or problem with my data?

Thanks in advance.

Sridhar

Re: Section Access - Access Point Issue

simospa — Fri, 05 Feb 2016 10:40:19 GMT

Hi,

try to take a look here: https://community.qlik.com/thread/179577

In particular, when it said:

NTDOMAINSID

A field that should contain a string corresponding to a Windows NT Domain SID.
Example: S-1-5-21-125976590-4672381061092489882
QlikView will fetch the logon information from the OS and compare it to the value in this field.

Then, are you sure that B-16-5-21-464368543-689502253-265866 is the same SID that results in the machine where are you trying to open the application in Access Point?

Re: Section Access - Access Point Issue

avinashelite — Fri, 05 Feb 2016 10:42:54 GMT

Since your using NTNAME & NTDOMAINSID it read the user from the network....so that might be causing the issue.

Try to comment the NTDOMAINSID and use the network valid name ....and then go with a vaild NTNAME

Re: Section Access - Access Point Issue

sridhar_sigired — Wed, 10 Feb 2016 11:04:36 GMT

Hello Team,

When we are using below script, reloading is failed. Can we add Server password also? or do we need to eliminate first line. Can we implement this method without server password?

ACCESS	USERID	PASSWORD	REGION
ADMIN	DomainName\Administrator
ADMIN	A	1	SOUTH
ADMIN	B	2	NORTH
USER	C	3	EAST
USER	D	4	WEST

Re: Section Access - Access Point Issue

avinashelite — Wed, 10 Feb 2016 11:09:31 GMT

are you trying to reload the document from the server ?? if so try to add the Qlikview Server >service account user name and password ..otherwise it will not allow you to reload from the server

Re: Section Access - Access Point Issue

sridhar_sigired — Wed, 10 Feb 2016 11:14:08 GMT

Oh, thanks Avinash. I think i will go ahead with NTNAME since service account password will not be shared by IT... thanks.

Re: Section Access - Access Point Issue

avinashelite — Wed, 10 Feb 2016 11:17:03 GMT

Yes, please go with that...NTNAME will solve most of the issue but it will be restricted to the login

Re: Section Access - Access Point Issue

sridhar_sigired — Wed, 10 Feb 2016 11:21:29 GMT

Yes Avinash. Thank you.

For example, if i give the access to the person who is not there in my section access table, does he get access to all the data?

For Example. USER A, B , C is there in my section access table and i have given access to

A,B,C,D...

So person D gets access to whole data? This is my general doubt. Have you ever tried?

Re: Section Access - Access Point Issue

avinashelite — Wed, 10 Feb 2016 11:27:36 GMT

No, the user who are not listed in the section access will not have access for the Qlikview document

in your case USER D will get a access denied error ....

In order to give the complete access you need to make use of the * option in the section access

Re: Section Access - Access Point Issue

avinashelite — Wed, 10 Feb 2016 11:29:55 GMT

check this :

QlikView Section Access Examples

Re: Section Access - Access Point Issue

sridhar_sigired — Wed, 10 Feb 2016 11:30:33 GMT

There is always confusion with this *...

Here in section access table * is nothing but access to all listen region on this section access table. Not all available in DB table.

I hope i am correct on this.

Re: Section Access - Access Point Issue

avinashelite — Wed, 10 Feb 2016 11:33:31 GMT

yes , your correct go through the document it will help you to understand ...if your not getting something your always welcome with any sort of questions