topic Re: Security rules - All my sheets disapeared in Management & Governance

Security rules - All my sheets disapeared

MNicolas — Sat, 16 Nov 2024 02:04:59 GMT

Hi all,

I'm designing the security for my Qlik Sense serveur and i'm using this video :

https://www.youtube.com/watch?v=feSaaJZ7Jco

I created a Stream Level Custom Property and a App Level Custom property, and apply this Custom properties to my user

I see the corrects streams and applications, but I can't see any sheets on all my applications now...

Here are my rules (I disabled App default security rule)

// 1. I can see the streams where the streamlevel CustomProperty match the user CustomProperty

Stream* ((resource.@StreamLevel=user.@StreamLevel))

//2. I can see all apps in streams where i havent set CustomProperty

App* (resource.resourcetype = "App" and resource.stream.HasPrivilege("read") and resource.stream.@StreamLevel.empty()) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read") and resource.stream.@StreamLevel.empty())

// 3. I can see the apps in streams where the applevel CustomProperty match the user CustomProperty

App*(resource.resourcetype = "App" and resource.stream.HasPrivilege("read") and resource.@AppsLevel=user.@AppsLevel) or ((resource.resourcetype = "App.Object" and resource.published ="true" and resource.objectType != "app_appscript" and resource.objectType != "loadmodel") and resource.app.stream.HasPrivilege("read") and resource.@AppsLevel=user.@AppsLevel)

Thanks for your help 🙂

Re: Security rules - All my sheets disapeared

MNicolas — Wed, 29 Jul 2020 08:10:56 GMT

Any ideas ?

Re: Security rules - All my sheets disapeared

rzenere_avvale — Wed, 29 Jul 2020 08:21:15 GMT

Good morning @MNicolas ,

on Second and Third rule you are trying to ask Qlik to verify if the custom property @AppsLevel applied to the App.Object entity (sheets, stories, ...) has a value equal to the same custom property applied to the user.

So far, you cannot apply custom properties on app objects...
I suggest to remove those highlighted rows from second and third rules. For regular users, visibility based on an applevel (as suggested by your custom property) is fine.
If you need to restrict visibility also on sheet level, then a different approach needs to be taken.

I hope this helps,
Riccardo

Re: Security rules - All my sheets disapeared

MNicolas — Mon, 17 Aug 2020 12:35:03 GMT

Thanks for your response!