I am using NAV 2009, where i have 4 super users and my clinet wants one of them to restrict to access only one company in the database through RTC. For that I followed the below steps first
From Classic client with SQL option, I went to Security-> Windows Login-> Roles-> Selected a company in the Company field.
System was throwing an error related to permission on Table 2000000073 when open the RTC. I went through some posts related to this and later did the following.
Imported the user Roles and Permission from UserRoles.xml and UserRolePermissions.xml file.
Assigned a BASIC role to the super user whom I restricted to access one company
Ran synchronise all logins
Now Icould able to connect to the database using RTC, but the user is able to access all the companys of the database.
While using the the User with Super User Access for all companies, Click tools>>>Security>>>Database Logins>>> (Highlight / Place Cursor / Select User ID)>>>Click Roles Button>>>Select Role ID>>>Slect the Company that is allowed only for that particular User.
Ofcourse, I set the permissions for Super user 2 using the Super User1, who has access to all companies and ran the synchronise logins. But It didnt work.