Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Section Access

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.

6 Replies
ecolomer
Honored Contributor II

Re: Section Access

You have two function to retrieve user:


QV User:  QVuser( )

Windows User:   OSuser()


For QlikView user is QVuser()

Not applicable

Re: Section Access

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

ecolomer
Honored Contributor II

Re: Section Access

sorry, I had not understood

Not applicable

Re: Section Access

Hi,

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

WanKi,

Not applicable

Re: Section Access

Can you be more specific and give some sample data.

Re: Section Access

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

Community Browser