Notifications
Announcements
No record found.
Hi All,
I need to find out the list of legal entites a User is having access to.
There is a chance of the user having multiple roles and also for each role it can have either specifc companies or all or have Organization hierarchy assigned,
Please suggest.
Thanks
Krishnendu
You can use SystemSecurityUserRoleOrganizationEntity data entity to get this list.
Hi Krishnendu,
The table UserDataAreaList is having a list of companies per user. There are also options to retrieve the list with selectable entities via coding.
SecurityRights rights = SecurityRights::construct(); container companies = rights.getSelectableCompanies();
Can you tell what you want to achieve? Then we can suggest the best option for you. Note that the System user role is not restricted and would cause providing a list with all legal entities.
Hi Andre,
I think the table your are are talking is UserDataAreaFilter and yes it contains all the legal entities.
We have a crosscompany upload functionality where we have a company column based on which we update some tables. If the user who is uploading doesn't have access it should throw error. Also the error log will have list of errored records so user with specific access to legal entities should be able to see the records.
SecurityRights rights = SecurityRights::newUser(userId);
container companies = rights.getSelectableCompanies();
this works but I noticed one thing if we provide any organization hierarchy and grant it to a user it doesn't add those legalentites ...
My bad, I intended to share indeed the table name UserDataAreaFilter.
Did you add the organization hierarchy to a user via a security role? If so, ensure the security will be reloaded. Most simple for testing is closing the internet browser with the Dynamics 365 session and start a new session.
Andre...yes thanks ...it worked after starting a new session...also for both the tables SECURITYUSERROLE & SecurityUserRoleCondition the values updated after starting a new session.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 646 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
