topic How to manage section access dynamicly in QlikView

How to manage section access dynamicly

Wed, 26 Dec 2012 11:30:06 GMT

Hi All,

I am trying to authenticate qv users using section access.

My code is basic and as following :

SECTION Access;

sql exec mySp ; // returns [ACCESS],[PASSWORD],USERID

Section Application;

My problem is it is not working dynamicly.

When first time I open the document everything seems ok,

but when I changed the password of any user in db and then reopen the document system accepts the old password.

How is it possible to check the authentication dynamically in every document opening with actual password in the db?

Note :I unchecked the 'Strict Exclusion' , and then close the document.

Regards,

Re: How to manage section access dynamicly

Wed, 26 Dec 2012 11:34:18 GMT

TRY IT

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, test1, password

USER, test2, password

];

Section Application;

Re: How to manage section access dynamicly

Wed, 26 Dec 2012 11:36:41 GMT

Go to Document Properties->Go to the Opening tab->Uncheck Initial data reduction based on section access .

Hope it help.

Dont forget to save and then open the application.

You can also see if User Properties->"Remember login credential until qlikview exists " is checked in General tab

thanks

Re: How to manage section access dynamicly

Wed, 26 Dec 2012 11:38:35 GMT

Hi vishwaranjan,

Thanks for quick reply but I don't want to use my qv document to manage after writing the script,

I want to manage authentication on database, so i can not use static content,

I need the user and passwords to be loaded everytime qlikview document opens.

Re: How to manage section access dynamicly

Wed, 26 Dec 2012 11:49:37 GMT

Hi,

still not working,

my problem is not the same as the thread 69065.

Detailed problem is as following:

Think that there is 3 or more users.

and one of them changed the password and they are not permitted to edit qv script.

To consistency I need the user's password to be changed automaticly and when next login or opening the qv document the user can be access the document with new password.

Re: How to manage section access dynamicly

sudeepkm — Wed, 09 Oct 2013 09:31:14 GMT

I think you can use NTNAME in your section access table.

Assume that you are keeping your USER Access info in a table then the table should look like below.

ACCESS,NTNAME,OMIT

USER,USERID1,FIELD1

USER,USERID2,FIELD2

USER,USERID3,FIELD1

ADMIN,SERVICEACCOUNTID,

This approach will work in Server. The QliView server will be integrated with either Active Directory or a Custom directory service. When the USER logs into Access Point QlikView server will take the User ID from the header and allows the user to see the document if the user id is listed under NTNAME field. We need to add the QlikView Publisher service account id under NTNAME and keep it as ADMIN so that no reduction is applied when the publisher reloads the document.

Please keep a backup version of your original qvw before applying section access.