Hi all,
I am building a model-driven app to keep, among other things, employee details. As suggested by Microsoft, when it came to add fields to an employee profile, I simple added them to the 'User' table. However, when we now try to restrict access through Security Roles, so that each user can only see their own data, we find that we can't lower the security access to the 'User' table below 'Business unit'. All other tables that I created from scratch, could easily be downgraded to 'User', so that users could only read their own data.
When I started working with this Dataverse database, the user list was already populated (and some fields are populated automatically when a new employee is added, I assume from MS 365 or something like that?).
Having a security role of 'System Costumizer', I find I can still see all information from other users, which I should not be able to.
I have thought about just creating a whole employee profile table from scratch just so that I can change the security settings, but I thought I'd come here and ask first, if there is a way to 'save' my 'Users' table 🙂.
Best regards,
RM
