topic Re: Access Restricted with CFG File in QlikView

Access Restricted with CFG File

marleygt — Wed, 22 Jul 2015 15:04:02 GMT

Hi Community!

Need some info and help for this situation:

several customers and one, unique, project;

I need to bound Access for some customers in order to prevent access on sensible data they cannot see.

To load specific customization for each customers, I've used CFG file which contains unique specification for any customers.

This is working perfectly.

Problem is securing access;

This is Sec.Acc. right now but I need to remove access for all the customers and let the CFG configure any single access for specific customer.

Section Access;

LOAD * INLINE [

ACCESS,USERID,PASSWORD,NTNAME,TYPE

ADMIN,ADMIN,,*,ADM

USER,*,*,QLIKSRVPRD\QVG_User_01,AG

USER,*,*,QLIKSRVPRD\QVG_User_02,AG

USER,*,*,QLIKSRVPRD\QVG_User_03,AG

];

Section Application;

In the CFG for first customers I set:

SET vUser='QLIKSRVPRD\QVG_User_01';

and what I was expecting is that CFG allow only Customer "User_01" to get in, but is not.

I think is my limit as a beginner in QlikView, but I am not able to find a solution for that.

There is any possibility to set this kind of restricted access?

Thank you!

Alex

Re: Access Restricted with CFG File

qlikviewwizard — Wed, 22 Jul 2015 15:15:37 GMT

I think it is better to use this way:

SECTION Access;

Security_Matirx:

LOAD * INLINE [

NTNAME,ACCESS

ADMIN,ADMIN

USERID1,USER

];

SECTION Application;

If we use NTNAME , no need to mention Password.

Hope this will help you.

If you have any doubt.

Please attach sample source files.

Thanks.

Re: Access Restricted with CFG File

marleygt — Wed, 22 Jul 2015 15:43:34 GMT

Thank you qlikviewwizard!

Well, to be honest I am not sure if I understand correctly; anyway, I am going to make some test with that, keeping in mind what you wrote.

Now I am going at home, tomorrow I should be able to let you know more.

In the meanwhile, thank you again!

Alex

Re: Access Restricted with CFG File

qlikviewwizard — Wed, 22 Jul 2015 15:50:45 GMT

Hi Marleygt

Surely. Thank you.