Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have about 20 company in one Navision database and I have around a few hundreds users having access to the Navision.
I would like to do a housekeeping to ensure that for those companies that wind up, users will no longer have access to them except my accounts team.
May I ask how do I remove the access from those normal users besides going to user roles and remove them one by one?
Besides, I can't recall who have the rights to the company that wind up. Do I have to go one by one to check all the hundreds over users?
maybe some custom report that will do that for you in one run, when you specify which company you want to delete.
Regarding checking, if you have access to the SQL there are the tables Access Control where you can find all permissions for all users together with Company name. The second table is User Security ID that represents each user. As this is guid, you can also find a list of users with their user security id in SQL table called User.
Hi joshlabtech ,
I don't think there is a standard feature available to list all users who belong to the assigned company. But you can develop a new report for this.
For the user permission, can you just try the user group functionality available in the user card. But not 100% sure whether this covers your point..
If you have access to DEV environment and can open Table Access Control (2000000053) you will see the Users, Companies, and Permissions.
Hope this helps.
Business Applications communities