topic Re: Application Security in QlikView

Application Security

tresB — Thu, 04 Jul 2013 10:30:02 GMT

Hello Everybody,

I have developed an application and our server is maintained by another person. So I have to give my application to him to host. Now what I want is : When someone(I don't want anyone else to modify my application) tries to open the application in desktop client mode, it should ask for password (admin). But when the same application is accessed through browser should not ask for password (it should be NTFS authentication). Is there anyway to achieve it?

Thanks.

Re: Application Security

alexandros17 — Thu, 04 Jul 2013 10:38:16 GMT

The Hidden Script Login dialog is opened fom the
command File - Edit Hidden Script in the Edit Script dialog. A password that will reveal the hidden
script must be entered in this dialog. Once the password is entered the script
will be accessible as long as the document remains open.

Re: Application Security

tresB — Thu, 04 Jul 2013 10:45:15 GMT

Hi Alex,

Thanks for your reply. I don't even want people open the application in desktop client mode without a password. I have to protect the UI expressions too. Any thoughts?

Re: Application Security

IAMDV — Fri, 05 Jul 2013 13:31:40 GMT

Hi tresesco,

This will work but you need to use Macro/VB Script. And It may not be elegant solution but it works for me. So here is what you need to do...

Step 1: Use the below VB Script and change the file path & document name

Sub CloseApp()

set App = ActiveDocument.GetApplication

Rem ** open new document and activate it **

set newdoc = App.OpenDoc("YourFieldPath\Comm_86100.qvw","","")

Rem ** back to ActiveDocument (= document running macro) **

ActiveDocument.Activate

Rem ** close new document again **

newdoc.CloseDoc

End Sub

Step 2: Now, use the Document Open Trigger and use "Run Macro" Action with the following expression.

=IF(ComputerName() <> 'YourComputerName', 'CloseApp')

This way whenever other users try to open the application on their desktop, QlikView would fire the Macro which would close the document. And it opens without any issue when you try it.

Also, tweak the Sheet & Document Property security settings.

I hope this helps! Good luck mate.

Cheers,

www.QlikShare.com

Re: Application Security

tresB — Tue, 09 Jul 2013 05:16:06 GMT

Hi DV,

A good one. At least I have got some idea. Thanks.

Re: Application Security

vikasmahajan — Tue, 09 Jul 2013 05:55:07 GMT

Deepak whether it is possible to secure my PAYROLL application , This Is developed in server and in server itself I want to open only by me no one other should allow to open it ,

Whether Can acheive the same ?????????

Thanks

Vikas

Re: Application Security

IAMDV — Tue, 09 Jul 2013 10:28:20 GMT

Anytime tresesco

Vikas - You can use OSUser() function which will return the NTName. I'm assuming that you're using AD authentication.

Good luck!

Cheers,

www.QlikShare.com

Re: Application Security

tresB — Fri, 19 Jul 2013 12:36:56 GMT

Deepak,

With this even the front end users (accessing through web browser) can't access the application. So, I have to apply something to spare the browser users from this security. Any idea?

Update: In fact, it works fine with 'Full Browser Version'. How can I achieve it irrespective of client types?

Update2: For a moment, felt like 'Got it !' but no. ClientPlatform() could have been used, but for IE it returns NULL same as when is in desktop client. so .