topic Re: sheet level security rule for specific user in Management & Governance

sheet level security rule for specific user

bhaskar — Mon, 24 Apr 2023 07:27:23 GMT

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.

Re: sheet level security rule for specific user

rubenmarin — Mon, 24 Apr 2023 11:48:47 GMT

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/824046

But adapted to Sense syntax: https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

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.

Re: sheet level security rule for specific user

Giovanni_Civardi — Mon, 24 Apr 2023 12:03:02 GMT

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-p/1485114/page/2/show-comments/true

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

Best,