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

PowerApp with read-only connection to SQL Azure

I'd like to create a PowerApp that links to a SQL Azure database and ensure that the user credentials specified in the PowerApps connection only have read-only rights to the tables. Are there any best practices for setting this up? Should I create a user in SQL Management Studio and only grant them read access to the tables? I'm new to SQL so if someone could provide steps on how to accomplish this it would be greatly appreciated!

 

Regards,

Pete

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

The rights to the SQL database will be dependent on the rights given to the connection account used in the SQL connector.  For Azure the connector will only accept a SQL account.  So create a new SQL login and assign that account ReadOnly access to the Database you want to use as the datasource. Then when creating your connection use that account.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

View solution in original post

1 REPLY 1
Pstork1
Dual Super User
Dual Super User

The rights to the SQL database will be dependent on the rights given to the connection account used in the SQL connector.  For Azure the connector will only accept a SQL account.  So create a new SQL login and assign that account ReadOnly access to the Database you want to use as the datasource. Then when creating your connection use that account.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,489)