App level Access in Qliksense but issue in app object access

[shraddha_g]

Hello Community,

I am trying to achieve App level access in qliksense.

I have used Qlik Sense Stream Management Security Rules and Exception Management this video which worked perfectly for restricting App in a stream.

But I am facing issue with Sheets after changing default Stream Rule and creating new rules.

Is there anything I need to change for Sheets or App Objects?

lakshmikandh‌

korsikov‌

rohitkumar1609‌

Please suggest.

[shraddha_g]

(resource.resourcetype = "App" and resource.stream.HasPrivilege("read") and resource.@AppLevelMgmt.empty()) or (resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read"))

This is newly created Default stream rule,which by default allows access to all app published in stream and custom property is empty.

AppLevelMgmt is custom property created for apps and users.

It works for apps. but then m not able to see sheets from those apps.

Old Default Stream Rule

(resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or (resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read"))

[lakshmikandh]

Sheets should be visible,

Try this way,

((resource.resourcetype = "App" and resource.stream.HasPrivilege("read")) or (resource.resourcetype = "App.Object" and resource.published ="true") and resource.app.stream.HasPrivilege("read")))

and resource.@AppLevelMgmt.empty()

[shraddha_g]

This is also giving me same result, hiding published sheets

[lakshmikandh · Accepted solution]

Did you sent user level custom property ? create and match like user.@AppLevelMgmt with resource property

[shraddha_g]

Deleting and recreating rules worked. now sheets are visible.

Thank you for your help.

[lakshmikandh]

Nice Happy Diwali.

[shraddha_g]

Happy Diwali to you too.

[MK9885]

Hi,

I've read this post and it was helpful....

I'm trying to create Sheet level access. I've defined all custom properties as mentioned.

I can create Stream level/App level but for Sheet level I cannot. And sometimes not all objects appear and throws an error.

1. 1.    Sheet Access

((user.@QStream="Q Stream" and resource.objectType="sheet" or user.@QUSERS="Q Users"))

1. 2.    App Access

((user.@QAPP=resource.@QAPP or user.@Group=resource.@Group ))

1. 3.    Stream Access

((user.@QAPP="Q APP" and resource.@QStream="Q Stream" ))

I just made simple set of rules for Stream/App and Sheet (full access) but I want to limit them to few sheets.

I added users to groups using custom property.

Please let me know where I'm doing it wrong...

lakshmikandh

shraddha.g

[shraddha_g]

did u follow d steps mentioned in video?

[MK9885]

I cannot open the video for security reasons at my work and from home I can't access hub. But I'll store this video link and make notes for what I'm missing.

But it would be of great help if you can paste your security rule for object based (Sheet level) and how to correctly define App and Stream rule where all objects are shown with our any error (object is missing, master linked object missing etc)

Thanks.