cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

What permissions does a user need for the SQL Server connection setup?

I am trying to connect to an Azure DB using the SQL Server connection and I am wondering what permissions a user needs to connect to this server. I have tried with a user who has read and write permissions to the table I want to connect to in PowerApps, however I do not see that working. Is there a base level of permission the user needs to the SQL server username and password? I want to make sure I am not giving the PowerApps users permissions they do not need.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: What permissions does a user need for the SQL Server connection setup?

Hi @PAB ,

Do you want to connect your app with azure SQL?

If so, you need to pay attention to these points:

1)have premium license( per app plan/per user plan)

2)need these data when creating connection

433.PNG

 

You need to know one sql account's username and password

3)the sql account that you use need to have read and write permission

4)the connected sql table needs to have primary key

5)sql view is read-only in powerapps

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: What permissions does a user need for the SQL Server connection setup?

Hi @PAB ,

Do you want to connect your app with azure SQL?

If so, you need to pay attention to these points:

1)have premium license( per app plan/per user plan)

2)need these data when creating connection

433.PNG

 

You need to know one sql account's username and password

3)the sql account that you use need to have read and write permission

4)the connected sql table needs to have primary key

5)sql view is read-only in powerapps

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,289)