Security rules by apps

kevinchevrier — Mon, 13 Nov 2017 09:02:39 GMT

Hi,

I follow this discussion (Sheet level Section Access in Qlik Sense ??) to hide a sheet in an app.

It works fine.

What I would like now is to hide one sheet on an app, and to show this sheet on another app (for the same user).

For example :

Stream 1 - App 1 - Without the sheet "Remuneration"

Stream 2 - App 2 (I duplicated the app 1) - With the sheet "Remuneration"

I have done 4 rules but it doesn't work :

- App 1 with the sheet "Remuneration"

Resource filter = App_id_of_the_first_app,App.Object_*

Conditions = ((resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read") and (user.@Rémunération="App one Yes"))

- App 1 without the sheet "Remuneration"

Resource filter = App_id_of_the_first_app,App.Object_*

Conditions = ((resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read") and (resource.objecttype="sheet") and (resource.name!="Rémunération")) and ((user.@Rémunération="App one No"))

- App 2 with the sheet "Remuneration"

Resource filter = App_id_of_the_second_app,App.Object_*

Conditions = ((resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read") and (user.@Rémunération="App two Yes"))

- App 2 without the sheet "Remuneration"

Resource filter = App_id_of_the_second_app,App.Object_*

Could you help me ?

My user has got these custome properties : "App one No" and "App two Yes"

Kevin

Re: Security rules by apps

shraddha_g — Mon, 13 Nov 2017 09:22:32 GMT

Refer Sheet or App Object Level Security Qlik Sense

Re: Security rules by apps

kevinchevrier — Mon, 13 Nov 2017 10:00:56 GMT

Thank you. I read the article. I understand how to do that for one app. But I don't succeed with 2 apps.

Re: Security rules by apps

shraddha_g — Mon, 13 Nov 2017 10:05:08 GMT

Using Custom Property might help you to generalize the rule

Re: Security rules by apps

kevinchevrier — Mon, 13 Nov 2017 15:06:33 GMT

Finally, it's ok. I use (resource.id=id_of_my_app) inside the condition and I change the filter conditions

topic Re: Security rules by apps in App Development

Security rules by apps

Re: Security rules by apps

Re: Security rules by apps

Re: Security rules by apps

Re: Security rules by apps