topic Re: Authorisation help needed… in QlikView

Authorisation help needed…

Thu, 18 Sep 2014 14:40:51 GMT

I have 2 tables as below: If User1 login to dash board, he should be able to view his related data etc…

I have to setup user authorisation accordingly. How do I setup?

SalesOrg	UserName
1001	User1
1001	User2
1001	User3
1003	User4
1002	User1
1004	User2
1004	User3
1005	User4
1006	User2
1007	User3
1008	User1
1009	User2
1009	User3
1008	User1
1007	User2
1006	User3
1006	User4

SalesID	UserName	Amt
1	User1	100
2	User2	200
3	User3	300
4	User4	400
5	User1	100
6	User2	200
7	User3	300
8	User4	400
9	User1	100
10	User2	200
11	User3	300
12	User4	400
13	User1	100
14	User2	200
15	User3	300
16	User4	400
17	User1	100
18	User2	200
19	User3	300
20	User4	400

Re: Authorisation help needed…

maxgro — Thu, 18 Sep 2014 18:53:21 GMT

see attachment (qlik doc and pdf for detailed help)

userid and password below

LOAD * INLINE [

ACCESS, USERID, PASSWORD, USERNAME

USER, USER1, U1, USER1

USER, USER2, U2, USER2

USER, USER3, U3, USER3

];

Re: Authorisation help needed…

Fri, 19 Sep 2014 15:58:47 GMT

Hi Massimo,

Very nice document you sent, I am exploring it. But my case is user will not provide any password, based on OSUser, I have make sure those filters. I hope it is possible. Can please guide me how to do that?

Thanks gain.

Re: Authorisation help needed…

maxgro — Fri, 19 Sep 2014 19:06:07 GMT

hope to understand: you want your user open the doc without input username/password

I changed section access using NTNAME field (see below), used my domain\ntname, reloaded the doc, saved the doc, closed and reopened Qlik and

I can see only record of USER2 without typing username and password (on my pc); also on the access point it works in the same way

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, USERNAME

USER, MYDOMAIN\MGROSSI, USER2

USER, MYDOMAIN\ANOTHERUSER, USER1

];

Re: Authorisation help needed…

Wed, 24 Sep 2014 15:49:00 GMT

Hi Massimo,

How do I load data from Databse instead of INLINE load?

Because all my user access data will stored in the database.

Please suggest?

Is below steps are correct?

OLEDB CONNECT TO xxxxxxxxxxxxxxxxxxxxxxxxxx;

SECTION Access;

UserTable:

LOAD Id as SalesOrg,

UserName;

SQL SELECT Id,

UserName

FROM xxxx.Users;

Is the authorisation will work based on the entries in the user table?

Can anybody help on this?