Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jordigonz
Contributor

Custom sheet access to particular users

Hi all,

I need to grant access by sheet for some specific users and I don't know how to do that. There are some post and information about this but is not easy to follow and zero intuitive.

My escenario is very simple:

  • 1 Stream: Sales
  • 1 App: Sales Analysis with 8 sheets (Sheet01...08)
  • 5 Users: User01...05

I need to limit the access to Sheet08. The users 1,2,3 must be able to open this sheet but the users 4 and 5 don't.

Any help?

Thanks in advance!

1 Solution

Accepted Solutions
hadooqlik
New Contributor III

Re: Custom sheet access to particular users

Hi Jordi,

Assuming you have access to the stream and the app of the sheets, you can create a custom property, called "sheet08" and value "yes" for example, and assign it to users that you want. Then create a security rule whose condition is that users who have the custom property to "yes" can read it.

Here an example: https://help.qlik.com/en-US/sense/2.2/Subsystems/ManagementConsole/Content/apply-access-rights-for-u...

Captura.PNG

You could also filter by id.

IMPORTANT! Take care with default qlik security rules like "Stream" which give read permission to app objects (sheets, stories...) if you have read permission on stream, because this rule would be giving read access to all sheets although you haven't done it.

I hope this help you

JuanJo

3 Replies
hadooqlik
New Contributor III

Re: Custom sheet access to particular users

Hi Jordi,

Assuming you have access to the stream and the app of the sheets, you can create a custom property, called "sheet08" and value "yes" for example, and assign it to users that you want. Then create a security rule whose condition is that users who have the custom property to "yes" can read it.

Here an example: https://help.qlik.com/en-US/sense/2.2/Subsystems/ManagementConsole/Content/apply-access-rights-for-u...

Captura.PNG

You could also filter by id.

IMPORTANT! Take care with default qlik security rules like "Stream" which give read permission to app objects (sheets, stories...) if you have read permission on stream, because this rule would be giving read access to all sheets although you haven't done it.

I hope this help you

JuanJo

reddys310
Honored Contributor II

Re: Custom sheet access to particular users

Hi Jordi,

Check this out:

Sheet level Section Access in Qlik Sense ??

Also, you will be able to find the properties for all the objects to write your own security rules here:

https://help.qlik.com/en-US/sense/2.2/Subsystems/ManagementConsole/Content/manage-site.htm

Thanks,

Sangram.

jordigonz
Contributor

Re: Custom sheet access to particular users

Hi Juan José,

Thank you so much, it was very usefull.

Like you said, the default "Stream" rule grant access to all sheets and streams. I had to disable Stream rule to check if works and so it is.

Now I guess that I must to set up new security rules for my streams...

FYI: I will follow this tutorial: Video Link : 3762

Regards