topic Macro to trigger login? in QlikView

Macro to trigger login?

Mon, 27 Apr 2009 15:00:23 GMT

Hi,

I would like to protect my qvw files from being altered by my customers. Hence, I used hidden script and an inline table to define the access rights:

Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD
 ADMIN, Smith, pass1
 USER, *, *
];
Section Application;

With this code, any person has user rights only when opening the qvw file, this hidden script is in. Now I'm searching for a macro I can use with a button object to trigger the login form, so the admin user can log in.

Is there such a macro or is there a better way to protect qvw files without forcing the regular user to use login and password but still giving the admin the possibility to alter the qvw when necessary?

Thanks,

Tankred

Macro to trigger login?

Mon, 27 Apr 2009 16:02:21 GMT

You could define user access based on NT security or like we did on QlikVIew serial number:


Users:
Load * INLINE [
SERIAL, ACCESS, PROFILE
3109 **** **** ****, ADMIN, ONTWIKKELAAR
3106 **** **** ****, ADMIN, ONTWIKKELAAR
*, USER, GEAVANCEERD_GEBRUIKER];

Macro to trigger login?

Mon, 27 Apr 2009 16:23:55 GMT

As you say, every user that accesses the document gets 'USER' access. This is because the '*' means any value and so no challenges are issued.

If the documents are server based, I would recommend you use NT authentication to control things and not worry about userid/password challenges. There is a Qlikview document 'Data Protection and Security' that explains this quite well.

Regards,

Gordon

Macro to trigger login?

Mon, 27 Apr 2009 16:26:18 GMT

@M. Janssen: Thank you for your reply.

That's actually what I've already tried. But I'd like to have the opportunity to do some on-site support without the need of using a certain installation/licence of QlikView. That's why I'd like to have something like an "admin login on demand".

@Gordon: thank you, too! But unfortunately, we don't have the server based solution, yet.

Macro to trigger login?

Mon, 27 Apr 2009 16:33:54 GMT

We have exactly the same problem, too bad I never found any good solution like the one you are suggesting (on demand login).

At this moment I have a build in condition in my reload script that looks if a certain file exists in the same folder, if that file exists in the same map no section access is loaded resulting in admin rights for everyone.
I just create this file myself and run a new reload and save the document. When I open the document again I have admin access. After my work I remove the created file and reload and save the application again.

It works but I would also prefer a better solution.

Macro to trigger login?

prieper — Mon, 04 May 2009 17:51:29 GMT

Hi,

normally the NT-User should do it but you need to explicitly assign the rights (USER or ADMIN) to each person. Alternatively you may simply define two groups with different logins: USERs / ADMIN.

The more elegant solution would be to assign different serial-numbers to the USERs, which then have to authenticate and the ADMINS, which do not need.

/Peter

Macro to trigger login?

Mon, 04 May 2009 19:13:11 GMT

Thank you but we've already discussed the things you've mentioned...

Macro to trigger login?

Wed, 04 Nov 2009 16:31:03 GMT

Hi,

do you know what i have to do for install QlikView 9.0 as Analyzer.

During a QConnect the Salesmas sad that "Is possible modify the register and QV work as analyzer"

Many Thanks

Claudio