Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
marleygt
Creator
Creator

Access Restricted with CFG File

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_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

3 Replies
qlikviewwizard
Master II
Master II

I think it is better to use this way:

SECTION Access;

Security_Matirx:

LOAD * INLINE [

NTNAME,ACCESS

ADMIN,ADMIN

USERID1,USER

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.

marleygt
Creator
Creator
Author

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

qlikviewwizard
Master II
Master II

Hi Marleygt

Surely. Thank you.