Answered

SQL Server Connection

(0) Share

Report

Posted on by unkleal21

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

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yuazh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

unkleal21 44 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No