article Sheet level access in Member Articles

Sheet level access

jagan — Fri, 07 Oct 2022 13:27:44 GMT

Hi,

This document helps in implementing Sheet level access based on the user using Section Access. I configured four users A, B, C and D and no password is required to login.

If you login as A, then you can see both Sheet1 and Sheet2.

If you login as B, then you can see only Sheet1.

If you login as C, then you can see only Sheet2.

If you login as D, then you can see both Sheet1 and Sheet2.

The user access is defined in the table

UserID	Sheet1	Sheet2
A	1	1
B	1	0
C	0	1
D	1	1

Hope this helps others in implementing Sheet level security.

Regards,

Jagan.

Re: Sheet level access

ali_hijazi — Fri, 13 Jun 2014 10:51:32 GMT

what is the user name and password

I downloaded the document and it asks me for a userID

Re: Sheet level access

Jason_Michaelides — Fri, 13 Jun 2014 11:23:26 GMT

Judging by the filename the UserID is either A, B, C or D and no password is required...

Re: Sheet level access

sergioabr_tocca — Fri, 13 Jun 2014 11:54:26 GMT

Hi,

Give it an A.

Re: Sheet level access

Mon, 16 Nov 2015 16:04:34 GMT

Hi,

How can i add a prompt message to say to the user when has no access ?

Thanks

Re: Sheet level access

jagan — Tue, 17 Nov 2015 00:31:59 GMT

There is no such option if you use section access, you can implement this manually, on Document Open trigger get current user and validate the user identity, if it is valid redirect to the Dashboard sheet otherwise show error message.

Re: Sheet level access

Fri, 08 Apr 2016 14:26:56 GMT

Hi all

can anyone please help me, why here i am unable login with user B and C. but i am able to login with A and D

Thank you

Re: Sheet level access

sunny_talwar — Fri, 08 Apr 2016 14:35:47 GMT

Not sure why, but after reloading the application, the login for B and C start working again.

Re: Sheet level access

Fri, 08 Apr 2016 14:57:17 GMT

oh gr8 yeah, after reloading it is working.

the funny thing is even my document was not loading with users , and it worked now after reloading now. but, i have reloaded it several times before, but its working now only.

Re: Sheet level access

Fri, 08 Apr 2016 16:29:53 GMT

Hi,

could you please look at it, if you can

Unable to login as User after implementing section access

Re: Sheet level access

Wed, 01 Jun 2016 07:53:26 GMT

Thanks for sharing . Good post

Re: Sheet level access

vireshkolagimat — Wed, 25 Jan 2017 12:15:59 GMT

Hi, it works fine if i give the userID as A but when i gave the userID as B, it says access denied to the Qlikview Document.

Re: Sheet level access

ahaahaaha — Wed, 25 Jan 2017 12:17:59 GMT

Good information. Thank you.

Re: Sheet level access

rohitk1609 — Thu, 16 Feb 2017 09:44:39 GMT

Hi,

To implement sheet level access step by step or more deep level App objects level access please refer this document:

Sheet or App Object Level Security Qlik Sense

Re: Sheet level access

anuradhaa — Mon, 01 May 2017 05:39:57 GMT

Is it possible to use qlikview user name to this sheet access directly (Direct Autentication) with out pop up a dialog box by asking the User Name

Re: Sheet level access

rohitk1609 — Mon, 01 May 2017 07:16:21 GMT

Can you please explain the concern in detail , Sorry

Re: Sheet level access

anuradhaa — Mon, 01 May 2017 12:39:45 GMT

I mean when i open attached QVW , it ask USER ID. So i don't want to implement that pop up.

I want qlikview to get user ID form loged user and Show data according to it.

Re: Sheet level access

rohitk1609 — Mon, 01 May 2017 14:32:26 GMT

Hi ,

When you open the QVW and it ask for user id and password , this is part of authentication. what we do in section access that is pat of authorization. If you donot wana that credential promt you may configure you network with single sign on, it means when you logged in with your machine in your local network it will give you authentication automatically to the server so when you try to get services by server it will not ask any user name and password.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Re: Sheet level access

Sivapriya_d — Thu, 07 Dec 2017 03:26:45 GMT

Hi,

Can try with NTNAME...it will work...

Thanks,

Siva

Re: Sheet level access

prasadmundewadi — Fri, 02 Feb 2018 20:41:53 GMT

stalwar1 I have seen this happening. Once you reload the app you have to close the app and reopen it then only the section access will work. Weird behavior I learnt it the hard way.