Answered

Delegation and Security Roles

(0) Share

Report

Posted on by Spamrancher

345

Anyone know the "order of operations" for delegation and security roles? For example, if my "Read" access is restricted to records in my Business Unit, and I have a non-delegable query, does Power Platform return the first 500 records of the table, or does it return the first 500 records of the table that I am eligible to view based on my Security Role? My suspicion is the latter, but I would like to confirm that. I cannot find that in writing anywhere. Any links would be appreciated.

Categories:

Microsoft Dataverse

Tables

All responses (2)

Answers (1)

Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Delegation and Security Roles

Hi @Spamrancher ,

The query will execute leveraging the user that is logged in so it will only return results from the database that are within the rights for the user to see, it does not filter the results afterwards. You may not find an article specifically to this. There are many ways to get data from the Dataverse including Web APIs, OData, FetchXML, etc. and all of these methods will only ever see the results the user is allowed to see with the Dataverse Azure SQL environment enforcing this.
Verified answer

Prakash4691 1,332 on at

Like (0)

Report

Re: Delegation and Security Roles

Hi @Spamrancher ,

You are right. It will return first 500 records which you have access to, if any non-delegable functions used in canvas apps.

If it answers your question. Kindly give kudo and accept it as solution.

Regards,

Prakash