topic Re: Allowing a user to create sheets but not edit load script in Management & Governance

Allowing a user to create sheets but not edit load script

FernandaNava — Mon, 03 May 2021 10:59:04 GMT

Hello,

I would like to know if there is a way in which a user can have access to the Edit Sheet features without being able to edit the load script. I know an analyzer can duplicate and create personal sheets but my requirement right now is for them to be able to edit the main app. This is for a Qlik Sense Enterprise deployment.

Thank you

Re: Allowing a user to create sheets but not edit load script

PadmaPriya — Mon, 03 May 2021 16:01:30 GMT

Hello @FernandaNava

Published apps in Qlik Sense are not editable.

Try like this:

1. Publish the app to stream (with or without task)

2. Duplicate the app and edit the duplicate in 'my work' area of hub

3. When publishing the duplicated and updated copy of the app , elect to 'replace' an existing app

Then nothing is lost that was tied to the original published version (personal content, tasks..). you are just bringing in new approved sheets, bookmarks and stories and a new load script.

Then, You should try the "Data Load Editor" for the UNpublished app. Thus the one you created by making a duplicate, accessible through "My Work". You should be able to edit that script, until the point where you publish (and replace) that one over the original.

If that doesn't work, you might have insufficient rights on that particular document. Check that app's security access rule, and your user and roles.

Disable edit in a published app is probably done by design, to prevent that your (auto)save of an Application's intermediate state immediately shows up for the users analyzing in the LIVE version of that app.

You do have to be careful though that you don't change the app in such a way that it breaks users work. Ways of doing this will be to delete (or break) Master Dimensions or Measures, or modify the data model.

Thanks,

Padma Priya

Senior Technical Support Engineer-Qlik Support

Re: Allowing a user to create sheets but not edit load script

Or — Tue, 04 May 2021 09:41:25 GMT

@PadmaPriya wrote:
Hello @FernandaNava
Published apps in Qlik Sense are not editable.

Hi @PadmaPriya ,

I don't believe that statement is accurate. Edit permissions can be given to people for published apps using security rules, or at least - that was the case in multiple prior versions of Qlik Sense Enterprise.

However, I think the question asked by @FernandaNava (and which I am also interested in if I understood is correctly) is whether we can allow someone to edit an app's layout, without also allowing them to edit the app's script. At least from my perspective, if they can VIEW the script that's fine, but I don't want them to edit the script, and it doesn't matter whether this is done in the published app or in a duplicated app. I can prevent people from running load scripts by not giving them permissions to the underlying data connections, but in that scenario they can still edit the load script and potentially break it.

Re: Allowing a user to create sheets but not edit load script

FernandaNava — Tue, 04 May 2021 11:43:35 GMT

Yes, thank you, this is exactly whay I'm asking. I know you can give or deny permission for a user to publish apps but I was wondering specifically about the load script.

Re: Allowing a user to create sheets but not edit load script

Marc — Wed, 05 May 2021 00:01:58 GMT

If you have a look at the Default Security Rules in Qlik Sense you will see a rule called "Stream"

this Grants the user the Read Action for Apps & AppObjects published within a Stream they have Read Access to.

However it Prevents Access to the App Script & Load Model. Which is why by default you cannot see the Script on a Published App.

@Andre_Sostizzo has published a KB on how this could be achieved.

Note: you can only Read the Script if you have both Read & Update permissions, Probably not great for a Production App.

https://community.qlik.com/t5/Knowledge-Base/Security-Rule-Example-Allow-access-to-Data-Load-Editor-on-an-app/ta-p/1716897

Re: Allowing a user to create sheets but not edit load script

FernandaNava — Wed, 12 May 2021 10:48:34 GMT

Thanks everyone for your contribution. I ended up using the security rules to allow users to publish and approve/unapprove sheets, so now they can add them themselves to the "base" sheets. I don't love this workaround but it's the best I could think of to avoid giving access to the data load editor.