I have a PowerApp that uses a SQL Server Connection. I need my employees to be able to use that PowerApp, so I shared the SQL connection with them. However, now that I share that with them, it looks like they are able to create flows to be able to access all the underlying data within the database. We are a healthcare company so it is important that they do not get access to data tables/views that they should not have access to. It seems to me like they could easily create a flow to export all the tables/views via email (Email has to be listed as a "business only" in the DLP).
Does anyone have any suggestions or workarounds?
Solved! Go to Solution.
If you share your SQL connection with your employees, they would get access to the data tables/views.
If you don't want the employees to get access to the data tables/views, please don't share the SQL connection with them, you could share your app with them and ask themselves to create their own SQL connection.