Hi,
If I understand well you requierement it's possible.
- If you grant access to some users to specified tables of dataverse, you can create a custom security role with this specified access.
Best practice: a custom security role copy of existing role "App Owner"
- After this, you can create a Security Team that be able to link this custom security role with a Security Group in Azure AAD.
- Configure this AAD group like a child of the Security Group of the environment.
- Configure the App owner like Owner that this Security Group.
With all this, if the owner of the application shares it with the group, it is ensured that all users already have access to the necessary dataverse tables.
Besides, like is owner of the AAD group, he can add or remove users in the group, without dependency of an admin.
Video: https://www.microsoft.com/en-us/videoplayer/embed/RWJBr8
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Regards
Alberto
