Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Governance and Administ... / Explicit vs Implicit -...
Power Apps - Power Apps Governance and Administ...
Unanswered

Explicit vs Implicit - Using Azure AD for SQL

(0) ShareShare
ReportReport
Posted on by CharlesBrewer 635

Hello,

 

My app is about finished and I realized I am sharing the SQL "implicitly" which turns out is bad.  I did some reading and I guess I have to use Azure AD handshakes to do it explicitly, how hard is this to do, or is there an easier way to do so? Can anyone kindly point me in the right direction? I would appreciate.

Categories:
Managed Environments
  • joe_hannes_col Profile Picture
    joe_hannes_col 1,843 Super User 2024 Season 1 on at
    Re: Explicit vs Implicit - Using Azure AD for SQL

    Glad to hear you solved it. Thanks for sharing 🙂

  • CharlesBrewer Profile Picture
    CharlesBrewer 635 on at
    Re: Explicit vs Implicit - Using Azure AD for SQL

    Oh hello, thanks for the response. That's actually what I ended up doing, I created a new environment and moved my app to it, where only I have any control.  Now in the default environment the SQL connection does not auto show and this brings me joy 🙂 Good to know they have updates on the way though I'll look into that, thanks again!

  • joe_hannes_col Profile Picture
    joe_hannes_col 1,843 Super User 2024 Season 1 on at
    Re: Explicit vs Implicit - Using Azure AD for SQL

    Hello @CharlesBrewer,

    There are multiple options to secure access to data in your case:

    1. There is a new feature in the pipeline that will ensure that even if you use implicit connections, the actual connection will not be available for other app makers. This will also be available for apps already developed. You can find more information here.
    2. You can move your app to a production environment by using solutions. In this production environment, you can make sure that other users do not have a role that allows them to create apps and flows. This will prevent them from creating apps and flows with the implicit connection you shared when you shared the app.
    3. You can set up your SQL and your connection to use another authentication method. You can find more information on this here.

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Apps Governance and Administering

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 11 Super User 2025 Season 1

#2
bscarlavai33 Profile Picture

bscarlavai33 5 Super User 2025 Season 1

#3
getsplash Profile Picture

getsplash 2

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans