Section Access

[#1]

Hi guys,

I am in dire need of help with section access. I have seen examples on how to go about creating the section access, as seen below.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, 1, 1

USER, 2, 2

USER, 3, 3

];

How should I go about scripting if I would like to retrieve the User_type - which is values 2, for users and 3 for admins, User_name - to login and User_pwd - to login. All of which is retrieved from MySQL.

Btw, I am a total newbie to QlikView. Just started this as I thought it would be good for my business. Please do help me.

Thanks

Wayne.

[ecolomer]

You have two function to retrieve user:

QV User:  QVuser( )

Windows User:   OSuser()

For QlikView user is QVuser()

[#3]

Sorry, I don't quite understand. Can I link the User_name from the database to be a QV User?

[ecolomer]

sorry, I had not understood

[#5]

Hi,

You mean what you want to know QV can get the user id and password from MYSQL ?

WanKi,

[#6]

Can you be more specific and give some sample data.

[ashfaq_haseeb]

Hi,

I think you have to retrieve information from database and Qlikview inline tables

and create and store a complete security table in your qvd after applying all transformations that you requires.

Then use this qvd and apply section access make sure to load this qvd unoptimized.

Regards

ASHFAQ