In this case instead of using Username & password as Section access fields use NTNAME . See below:
UPPER([ACCESS]) as ACCESS,
UPPER(NTNAME) as NTNAME,
Here inside a excel sheet create two heading ACCESS & NTNAME .
In Section Access, NTNAME should contain for every user:
The last one allows you to authorize access to entire groups oif users in one stroke, for instance COMPANYDOMAIN\NETPORTALVISITORS.
domainname is the name of the AD domain in which this user is defined. username is the accountname of the user when loggin into Windows.
The AD account of the current visitor will be compared with every NTNAME value in your Section Access table. If found, your visitor will be granted access.
In my case user logs in to .NET portal, then if he click some link then the qlikivew report opens.
I need to join the U_ID of .NETportal with the user id in section access table.
So can i use NTNAME for?
I have to use .NET portal's active directory right?
And if they have active directory then i can use it in NTNAME?