Announcements
I have created an app that uses a SQL connector. I am planning on creating a AD group called “SG-PowerAppUsers” security group and also giving users access to the tables in SQL. My question is do users need full access to the DBO table in the SQL server side? For example all the permissions below or do they only need alter and insert controls when it comes to the tables?
@NitroPepsi
Depends on what you plan to do in the app!
At the very least, they will need select permissions (read). Beyond that it depends on what you are doing. If you are writing back, then they need Update. If needing to delete, then Delete.
I hope this is helpful for you.
Yes, it is! Thank you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
