Power Platform Community Forum Thread Details

When you have established a connection to an SQL server, you are able to share this connection with everyone in your organization. So, if a user does this, then everyone is able to use the users credentials to connect to the SQL database in question.

In our org, we have seen that some users have shared an SQL connection with the whole org, and this is not something that we want them to do. So, this post has 2 questions.

1. Is it possible to disable this in any way?

2. When the connection is shared with the whole org, why is it so that only the connection owner can remove the access? Should it not be possible for a Power Platform Admin to do the same?

Categories:

Governance & administering

1) You can disable the use of the SQL connection in one or more environments using data policies in the Power Platform admin center. But I'm not aware of any way to disable the use of just shared connections. Also, the SQL connection is only shared if your SQL server is using SQL authentication or on-premises Windows Authentication. If you limit your database to Azure AD authentication then any connection created will be non-sharable.

2) The feature to secure these Implicit Shared connections is in Preview, but has been enabled by default. The documentation you are seeing is a bit outdated. You can read more about Secure Implicit connections here: Overview of connectors for canvas apps - Power Apps | Microsoft Learn