Skip to main content

Notifications

Power Platform Community / Forums / Microsoft Dataverse / Can users be prevented...
Microsoft Dataverse
Answered

Can users be prevented from editing Dataverse outside of a Power App?

Posted on by 447

Greetings, community. I have a scenario where I want to let users work on data in the Dataverse BUT I want to ensure that their only means of working on records is via a Power App + Power Automate flows. I want to be sure that people can't manually go in or create their own apps/flows to change data directly. Is there some way to achieve this with the Dataverse?

 

If this were a traditional DB, this might be achieved via a service principal/account, so users wouldn't have direct access and had to use an application interface.

  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 317 on at
    Can users be prevented from editing Dataverse outside of a Power App?
    • Direct table access in Dataverse is restricted based on security roles.
    • Even if User B shares a hyperlink, User A will not gain access unless their role allows it.
    • To manage this effectively, assign custom security roles or adjust existing roles to ensure the correct level of access (or lack thereof) for both app interaction and direct table access.
  • pmesiha Profile Picture
    pmesiha 46 on at
    Can users be prevented from editing Dataverse outside of a Power App?

    there are actually a back door, MS introduced preview features last year to allow to connect to dataverse tables in a different environment form Power Apps/Power Automate, with this approach. if you have your data in one env where users have access to only modify the data on some tables based on the assigned security roles. users can still create an app in the "Default" environment, and connect to the table they have access to in a different environment. 
  • Ami K Profile Picture
    Ami K 15,654 on at
    Re: Can users be prevented from editing Dataverse outside of a Power App?

    @arpost - users are only permitted to create flows in the default environment. They will not have permission to create or update flows in your environment unless they have the required security role (e.g. a non admin role such as Environment Maker).

     

    Further reading:

     

    https://learn.microsoft.com/en-us/power-automate/desktop-flows/desktop-flows-security 

  • arpost Profile Picture
    arpost 447 on at
    Re: Can users be prevented from editing Dataverse outside of a Power App?

    Thank you for your reply, @Amik. That's good to know. So would a similar thing happen if User A attempted to create a Power Automate flow that interacted with the Dataverse table or a Power App? Basically, I want to be sure there isn't a hidden backdoor that a person could use to access the data.

  • Verified answer
    Ami K Profile Picture
    Ami K 15,654 on at
    Re: Can users be prevented from editing Dataverse outside of a Power App?

    @arpost -

     

    If we're not talking about security in Dataverse for Teams (which is controlled by the Office 365 Group), Dataverse works under the principle of least privilege/deny by default. Only users who are granted either a Dynamics 365 Service Admin, Office 365 Power Platform Admin, System Admin and System Customizer role will have access to the underlying tables.

     

    Users would not be able to directly access underlying data unless the correct security role have been granted. Let's suppose for example that User A has been granted a security role which grants access to the Canvas App, as well as permission to read, edit, and create items in Dataverse table used by the Canvas App. However, User B (who has one of the Admin or Reader roles) copies the hyperlink to the Dataverse table and then shares that link with User A; this is what User A will see if they opened that link:

     

    Amik_0-1710356873055.png

     

    Further reading: https://learn.microsoft.com/en-us/power-platform/admin/database-security

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

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard

Featured topics