topic Re: Access in QlikView

Access

Fri, 21 Dec 2012 10:24:52 GMT

Hi All,

I have prepared one qlikview application . Now i want to give this application to different users(Not on access point ) . I want to give ADMIN rights to me and my partner and i have to give user rights to some user s(so that they should not have modification rights or to see the script) . How can i set this. Please explain in detail.

Re: Access

jagan — Fri, 21 Dec 2012 10:51:45 GMT

Hi,

You can restrict this by using Section Access, for you specify Admin access and for other users you give User access. So everytime users try to open the file, user name and password is required.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, test1, password

USER, test2, password

];

Section Application;

Regards,

Jagan.

Re: Access

Fri, 21 Dec 2012 13:54:36 GMT

Hi Jagan,

I gave my name in admin but when i am trying to reload it is not reloading . If i take the section access then it is reloading . Please help

Re: Access

Fri, 21 Dec 2012 13:56:06 GMT

i have written the section access script in hidden script . is it causing the problem . Please explain

Re: Access

Fri, 21 Dec 2012 14:04:17 GMT

If i login as user , i can reload and do all activities as admin . How to set properties

Re: Access

jagan — Fri, 21 Dec 2012 15:32:07 GMT

Hi,

PFA file for solution.

Goto Document Properties -> Security -> Edit Script -> Uncheck the options which do not required for normal user.

Now Give module password by clicking "Module Password" in the same tab.

In the attached file when you login as Admin then if you want to reload or change script then uncheck the options done above and after completion do the same security settings defined above.

Admin User Name & Password : Admin & Password.

Normal User Name & Password : Sales & Password1

Hope this helps you.

Regards,

Jagan.

Re: Access

Fri, 21 Dec 2012 15:55:43 GMT

Working, but even if i loggin as user i am able to move the Sheet objects , My requirement is if some one logins with user credentials they should not have the rights to move the object s.Please suggest

Re: Access

jagan — Sat, 22 Dec 2012 09:37:01 GMT

Hi,

Try Object Properties -> Layout -> Options -> Uncheck Allow Move/Size and Allow Copy/Clone.

Regards,

Jagan.

Re: Access

Sun, 23 Dec 2012 06:28:11 GMT

Hi Jagan,

thanks for the help i will check and will come back to you

Re: Access

ngulliver — Wed, 02 Jan 2013 12:01:24 GMT

Hi, Avi.

I would recommend having a look at Steve's blog for Section Access.

http://www.quickintelligence.co.uk/help-ive-locked-myself-out/

It gives you an idea of best practices and pitfalls.

Alternatively, there is a new book out called 'QlikView 11 for Developers' that has a good section on security.

Regards,

Neil