Hello all,
I have a Power Platform architecture where I'm developing a canvas app in environment DEV, and pushing a managed solution package to environment PROD every once in a while. My problem/question is with the user roles as I'm using Dataverse as my data source and I need to ensure row-level security in the PROD environment as the content in there is very confidential.
Let's say Developer A develops the canvas app solution and database in environment DEV so they need the "System administrator" user role. I don't want Developer A to have "System administrator" user role in environment PROD as the admin user role has full access to Dataverse tables in the environment.
For some reason I have seen behavior where assigning admin role in the DEV environment also resonates to the PROD environment even though the PROD environment user roles weren't touched in the PROD environment.
Is it supposed to work like that? Is there any way I could control the user roles so that they don't resonate between environments?
Thanks in advance,
Ville