web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / What is the fastest wa...
Small and medium business | Business Central, N...
Suggested Answer

What is the fastest way to check user's accesss for which company in Navision 2018?

(0) ShareShare
ReportReport
Posted on by joshlabtech 662

Hi,

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?

Thank you

I have the same question (0)
  • Suggested answer
    Renato Fajdiga Profile Picture
    Renato Fajdiga 1,855 on at

    Hi,

    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. 

    pastedimage1620284159095v1.png

    pastedimage1620284168792v2.png

  • Suggested answer
    ShanAbeywicrema Profile Picture
    ShanAbeywicrema 948 on at

    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..

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Josh,

    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.

    Thanks,

    Steve

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.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,164 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,242 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,197 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans