[Client Managed] Custom Rights on Data Connections in an App

[YannCourtet]

Hi,

I want to give a few Key users the ability to refresh an application on demand with a button in the App.
I created the 2 security rules on App and App object script, and it works, except when the user does not has read access to the data connections used by the App.

My application use a data connection, were there are some sensitive data. Users should not have the right to access this data connection, except if they are in the application (they can just run the script, so they don't have direct access to it).

Is it possible to create such a security rule ?

I tried the 2 following formula (with resource filter DataConnection_*, App*) but it doesn't work (Custom property _UserReload is set to Users / Apps that can performs on demand refresh).

• ((user.@_UserReload = "Allowed" and resource.@_UserReload = "Allowed"))
• ((user.@_UserReload = "Allowed" and resource.app.@_UserReload = "Allowed"))

Is it possible to do it ?

[ajaykakkar93]

Hi,
this is my playlist of important QMC rules in action: https://www.youtube.com/watch?v=DP1FAUL3MH8&list=PLYjPUKwx_ZbcVHWCHotTlE_Ct72kLTnKB

One solution for you can be to give access to data connection using the security rule: https://www.youtube.com/watch?v=jX4lwSToDNI&list=PLYjPUKwx_ZbcVHWCHotTlE_Ct72kLTnKB&index=6

[YannCourtet]

Hi,

It does not do what I want to do :
- If the user create a new App, the data connection should not be available.
- If the user is in the App with the refresh button, the data connection should be available.

[ajaykakkar93]

On-demand is one of the option but in you case you need to create a custom module to perform this activity which is possible.