cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alexlorenzo21
Advocate II
Advocate II

SQL Server Connection

Hello,

 

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?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

I figured out the issue. The connection was being used in a sharepoint customized form (not a standalone app). They were unable to use the form unless I shared the connection.

I am able to do what you recommend if it is an app. Are you aware of any way of being able to share a customized form in that same manner?

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @Alexlorenzo21,

 

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.

 

Best regards,

Alice

I figured out the issue. The connection was being used in a sharepoint customized form (not a standalone app). They were unable to use the form unless I shared the connection.

I am able to do what you recommend if it is an app. Are you aware of any way of being able to share a customized form in that same manner?

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (1,777)