Creating a read only role to access specific tables

(0) Share

Report

Posted on by RamuV

Hi,

I needed a role to be given to a third party team to only view certain data like CustTable, SalesLines, SalesTable etc. so that they can run Power App queries to access data in their system.

I created the role and assigned to a user. But he is not able to view the tables.

He is getting an error as below:

Can someone help me how to create a role and assign only a subset of tables and with read access only. This role will have to assigned to a user.

Many Thanks in advance.

Best Regards

Ramu

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

André Arnaud de Cal... 300,721 Super User 2025 Season 2 on at

Like (0)

Report

RE: Creating a read only role to access specific tables

Hi Ramu,

Power Apps are not using the tables, but data entities to access the Dynamics 365 F&O data. You would need to create a privilege with the entities used by the Power App. You can set the entity access to read only.

Was this reply helpful? Yes No
Verified answer

Hana Xue Microsoft Employee on at

Like (0)

Report

RE: Creating a read only role to access specific tables

Hi RamuV,

By querying relevant information, solutions to similar problems is found for you. You can try the descriptions in the screenshots, or you can check the problems and discussions in the following link.

Solved: PowerApps+CDS. "User XXX is not authorized to read... - Power Platform Community (microsoft.com)

User is not authorized to read view WorkflowWorkItemEntity. Request denied. - Dynamics 365 Human Resources Forum Community Forum

Best Regards,

Hana

Was this reply helpful? Yes No
Verified answer

Sreesha 35 on at

Like (0)

Report

RE: Creating a read only role to access specific tables

Hi RamuV ,

While creating the data entity, two privileges gets created automatically(privilege name ending with (Maintain and view).

You can assign the 'View' privilege to provide read access. Your error message is clearly saying that user is not authorized to access 'SalesOrderHeaderV2 entity', because PowerApp access data entities not tables as Andre said in above comment.

To see the roles associated to data entity, you can right click the entity and go to Add-ins -- > View related roles. You will get the list of roles associated to this entity. You can pick the read only from the available roles or you can create a new role and add the View privilege of the data entity.

Best regards.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

RE: Creating a read only role to access specific tables

Hi, As suggested above, you can try providing access to SalesOrderHeaderV2Entity Data entity to their security role. Security privilege is 'View sales order headers'.

Was this reply helpful? Yes No