sheet level security rule for specific user

[bhaskar]

Hi,

I want to create a sheet level security rule for one user.

stream : br_reports

App Name : Prod_report

Sheet : sheet1 , sheet2 & sheet3

user name : 1234

Now i want to create security for only  one user has to view the sheet2 sheet3

for that created custom properties as SheetAccess and selected users in resource type and added sheet2 & sheet3 in custom property values.

after that selected user 1234 and added sheet2 & sheet3 in SheetAccess section.

so little confusion here every one can access the three sheets.

can you please help me to how to write a security rule for this issue.

[rubenmarin]

Hi, since the option to set the show condition in each sheet I think it's more manageable to use this option and a section acces like in this script: https://community.qlik.com/t5/QlikView-App-Dev/HOW-TO-RESTRICT-SHEET-ACCESS-WITH-SECTION-ACCESS/td-p...

But adapted to Sense syntax: https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...

Using this you can manage access from an inline table or an external file or database that stores the access for each user/app/sheets, and it works for OnPremise and on Qlik Cloud.

[Giovanni_Civardi]

I would recommend to use Sheet Show Condition available from Qlik Sense Feb 2021.

https://www.youtube.com/watch?v=33tBUbRb6fk

If you want to manage via security rules take a look also at this link:

https://community.qlik.com/t5/Qlik-Sense-Documents/Sheet-or-App-Object-Level-Security-Qlik-Sense/ta-...

Please keep in mind that sheet show condition is not a security function, use section access instead.

Best,