Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to manage section access dynamicly

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,

5 Replies
Not applicable
Author

HI

TRY IT

SECTION Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, test1, password

    USER, test2, password

];

Section Application;

Not applicable
Author

hi

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

Not applicable
Author

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.

Not applicable
Author

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.

sudeepkm
Specialist III
Specialist III

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.