topic Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide? in App Development

Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

joshabbott — Fri, 04 Nov 2022 20:08:01 GMT

On our Qlik Sense instance, any user that has created their own sheet in 'My Sheets', the sheet automatically shows to all users 'My Sheets', even if they aren't published. I'm assuming this is a security setting or something, but can't seem to find it. I only want sheets created by the individual user to show in 'My Sheets' unless a sheet has been published.

Thank you!

Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

Rockstar7 — Sat, 05 Nov 2022 06:29:38 GMT

@joshabbott check stream related security rules in the QMC, The Actions should be read,publish only

Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

ckarras22 — Sat, 05 Nov 2022 07:12:00 GMT

Hello,

It is a Security Rule issue. Someone might have overiden this one (removed the " and resource.published ="true" " part?!?)

Stream

Stream security rule properties
Property	Details
Name	Stream
Description	Everyone who has read rights to a stream should also have read rights to a resource published to that stream
Resource filter	App*
Actions	Read
Context	Both in hub and QMC
Type	Default
Conditions	(resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read"))

Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

joshabbott — Mon, 07 Nov 2022 15:48:15 GMT

Thank you!

Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

pankajs — Mon, 28 Nov 2022 05:40:18 GMT

Hello,

Can you please elaborate whether we need this condition true or false.

resource.published ="true"

I don't want other users Sheet to be visible to all. My sheets should showcase only sheets created or duplicated by me.

Kindly assist.

Thanks for your support.

Re: Qlik Sense - My Sheets - All users see all user created sheets, how to hide?

ckarras22 — Sun, 04 Dec 2022 00:31:25 GMT

Hello @pankajs

resource.published ="true", applies to whatever "Resource filter" of a Security rule. In the case of Stream's security rule, it is both at the Application level and the Object level, like Sheets etc (because App*)

To understand and replicate what is the issue of @joshabbott (as well yours, in your other post) just follow the steps bellow in a clean installation of QS (if this is possible).

1) Duplicate Stream security rule, name it Stream2. Change resource.published ="true" to resource.published !="true". Disable Stream.

2) Login as User1 and open a published app. **Any of the published sheets have disappeared but ignore this fact**. You will see all of your unpublished sheets and from all other users.

3) Login as User2 and open the same published app. The same thing. All unpublished "My Sheet"s will be available to this user as well.

BTW, by checking in the stream's Actions the Publish one, doesn't resolve the issue. We select the Publish Action, to give the user the ability to right click the "My Sheet" and publish

**Please note that the resource.published !="true" is not necessary to be in the Stream2 SR, but in any of your custom ones**