Custom sheet access to particular users

[Anonymous]

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!

[Anonymous · Accepted solution]

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...

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

[reddy-s]

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.

[Anonymous]

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