Limit access to Community Sheets

vegard_bakke — Sat, 16 Nov 2024 19:59:58 GMT

Hi all, a tine security rule nut for a Friday afternoon 🙂

My aim is to limit read access to Comunity sheets, to certain groups.

I have been able to restrict the ability to create and publish Community sheets to only the custom Role = 'Editor':

Disable the default rule: CreateAppObjectsPublishedApp
Create rule:
1. Resource filter: App.Object_*
2. Actions: Create
3. Conditions:
  !resource.App.stream.Empty() and
  resource.App.HasPrivilege("read") and
  (resource.objectType = "userstate" or resource.objectType = "sheet") and
  user.roles = "Editor"

(Not sure what the objectType "userState" is, but left that in from the CreateAppObjectsPublishedApp rule.)

This works. Only Editors get the 'Edit' button, and they can create and publish Community sheets.

Now the part I need some guidance

Lets assume 4 users:

Alice - Group A - Editor
Allan - Group A - Normal user
Betty - Group B - Editor
Bob - Group B - Normal user

Alice and Betty can create Comunity sheets, but neither Allan og Bob can. (This works at the moment.)

But currently, both Allan and Bob can the the Community sheets that Alice created.

My aim is that only Allan can see the the Commmunity sheet that Alice created. And only Bob can see the sheet that Betty created.

My plan

The way I see it, the first step is to:

A) Find what default rule allows the users to Read Community sheets, and disable that.

B) Create a new rule that takes into account the Group of the user and the owner.

Does anyone have any suggestion to this?

Thanks a lot in advance. Any tips and partial solutions are welcome. 🙂

Cheers,

Vegard

Re: Limit access to Community Sheets

sasikumar — Fri, 25 Oct 2019 05:21:45 GMT

hi,

refer the following link - i hide a sheet based on sheet name. it can hide both published and community sheet.

https://community.qlik.com/t5/Qlik-Sense-Deployment-Management/QlikSense-Admin-Access-on-Stream-leve...

Thanks,

Sasikumar

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

topic Limit access to Community Sheets in Management & Governance

Limit access to Community Sheets

Re: Limit access to Community Sheets