topic Re: Security Rule to hide base sheet in App Development

Security Rule to hide base sheet

ali_hijazi — Thu, 03 Aug 2023 13:32:05 GMT

Hello got a QVF file named Finance P&L Dashboards
in this file I got a base sheet named DB_TIMES
I want to hide this sheet temporarily for all users
I created the below security rule:

but I'm still able to see the sheet if I open the dashboard from the hub

Re: Security Rule to hide base sheet

Or — Thu, 03 Aug 2023 14:06:36 GMT

Presumably, there's another rule (perhaps one of the default rules) that allows access to this sheet? You can't actually create exclusion rules, only inclusion rules, so if this rule includes every sheet except one and that one is still showing, a different rule is most likely to be at play.

Re: Security Rule to hide base sheet

Aurelien_Martinez — Thu, 03 Aug 2023 14:15:31 GMT

Hi,

To add to @Or

You can see the rule called "Stream" (The user should see the resource if he/she has read access to the stream it is published to)

But a simple way to achive this is the Show/Hide condition in the sheet.

Re: Security Rule to hide base sheet

Or — Thu, 03 Aug 2023 14:16:42 GMT

But a simple way to achive this is the Show/Hide condition in the sheet.

This does not act as security. Users with the right to duplicate / create sheets will be able to access the hidden sheet by making a copy of it.

Re: Security Rule to hide base sheet

ali_hijazi — Thu, 03 Aug 2023 14:28:04 GMT

so how can I hide this sheet from the users using a security rule?

Re: Security Rule to hide base sheet

Aurelien_Martinez — Thu, 03 Aug 2023 14:28:18 GMT

You right ^^

It depending on risk you can take. Changing security rule can be tricky 😐

Another solution can be to unpublish and unapprove sheet. The sheet still exist but only the owner can see it.

Re: Security Rule to hide base sheet

Aurelien_Martinez — Thu, 03 Aug 2023 14:30:27 GMT

I have found this

https://community.qlik.com/t5/New-to-Qlik-Sense/Sheet-level-Section-Access-in-Qlik-Sense/td-p/789067

Re: Security Rule to hide base sheet

Or — Thu, 03 Aug 2023 14:35:03 GMT

You will need to find the security rule(s) that enable access to sheets and disable them. I'd suggest you be careful about this and do it in a test environment first to make sure you aren't breaking anything important.

I think the default rule in question is covered here, section 4.1:

https://community.qlik.com/t5/Qlik-Sense-Documents/Sheet-or-App-Object-Level-Security-Qlik-Sense/ta-p/1485114?_ga=2.96645599.1311471234.1535608461-149838098.1525342031

Re: Security Rule to hide base sheet

ali_hijazi — Thu, 03 Aug 2023 14:57:42 GMT

Several discussions point to this article which is unclear
and it is about giving access to stream
anyways it seems this is a very vague / complicated issue

Re: Security Rule to hide base sheet

Or — Thu, 03 Aug 2023 15:34:01 GMT

Perhaps, but then again, a security rule hiding a single sheet is a pretty obscure issue, so it stands to reason there's no clear and easy way to do it a the click of a button. You can use show/hide conditions as suggested by @Aurelien_Martinez if you want a simple approach.