Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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:
Please keep in mind that sheet show condition is not a security function, use section access instead.
Best,