Unanswered

Change ownership SQL connection

(0) Share

Report

Posted on by aftabp

One of our developers who is the owner of this connection on PowerApps does not work with us anymore.
He is still the owner of the SQL connection.
How do i change the ownership to me?

Categories:

Governance & administering

I have the same question (0)

All responses (3)

Answers (0)

AlbertoCastro 1,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,
you could change the owner from powershell:
Set-AdminPowerAppConnectionRoleAssignment -PrincipalType Group -PrincipalObjectId [Guid] -RoleName CanEdit -ConnectionName [Guid] -ConnectorName shared_vsts -EnvironmentName Default-[Guid]
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Regards
Alberto

https://learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/set-adminpowerappconnectionroleassignment?view=pa-ps-latest

Was this reply helpful? Yes No
aftabp 32 on at

Like (0)

Report
Copy link

Link copied!

i am very new to this so here are a few questions:
where do i find all the GUIDs?
is there a way to do it with Flows?

Was this reply helpful? Yes No
AlbertoCastro 1,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, you can use the connector Power Apps for Admin to retrieve connecion information and edit the permissions:

https://learn.microsoft.com/en-us/connectors/powerappsforadmins/
https://learn.microsoft.com/en-us/connectors/powerappsforadmins/#edit-connection-role-assignment-as-admin

Was this reply helpful? Yes No