Community Center | Not monitored
Tag not monitored by Microsoft.
On-Prem Data Gateway SQL connection security considerations
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 94%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Tori
1
Reputation point
Hello,
My organisation is in the process of scoping out the use of an On-Prem Data Gateway.
Our initial aim is to use the gateway to allow a Power Platform app access specific data from an On-Prem SQL database.
I have little experience with PowerApps and have found it challenging to identify information on correct securities and how to lock down the data.
Some of the questions I have to date are:
- Should a data connection be made via a dedicated account or can the end users credentials be passed in.
- Is it possible to lock the data connection down to a specific SQL command to avoid giving the user visibility of all tables & views within that schema
- If the data connection is shared with the developer, is it accessible to end users of their app or can they only see the data on the screen?
Mainly I’d like to get a handle on the security considerations & mitigation recommendations but I haven't found anywhere online that addresses these issues.
If anyone has any advice or could direct me to relevant documentation it would be greatly appreciated.
Thank you,
Tori
Apologies if this post is tagged incorrectly or on the wrong form, i couldn't identify any tags related to the On-Prem Data Gateway; Power Apps or Connection security.
Community Center | Not monitored
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bruno Lucas 4,436 Reputation points MVP2022-05-06T04:40:59.11+00:00 Hi @Tori
Those questions are specifics of the power platform. You may get better answers here: https://powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1
The QnA is for the Azure side. We can help with answers on how to set-up the on-prem Gateway, but I see you want to know about security and access on the Power Platform side. That may be a good point to start: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/sql-server-security. You probably want to use a "explicitly shared connection". More here: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/share-app-resources
-
Tori 1 Reputation point
2022-05-06T16:19:14.68+00:00 Thank you! I'll see if these can bring be closer to my solution.
Really apricate your time and guidance.
Tori
Sign in to comment
Sign in to answer