Restricting a Super user to access Only one company

venu258

Hi All,

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

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

1) Imported the user Roles and Permission from UserRoles.xml and UserRolePermissions.xml file.

2) Assigned a BASIC role to the super user whom I restricted to access one company

3) Ran synchronise all logins

4) Restarted the services.

Now Icould able to connect to the database using RTC, but the user is able to access all the companys of the database.

Please guide me how to resolve this.



Thanx in advance.....

Venu.

mohana_cse06

venu258 wrote:

2) Assigned a BASIC role to the super user whom I restricted to access one company

Try without adding this role and assigning a company name to super role only
Restart the service..

venu258

System is throwing an error says 'No access to codeunti with id 1', when opening RTC.

mohana_cse06

Can you show the roles setup? and also permissions setup for super role
is super role a standard one or have you modified any permissions?

venu258

I didn't modify the base Super role permissions. Please look at the attachment.

mohana_cse06

I hope you have assigned Copmany Name to super role (which is not visible screenshot).
is this error message throwing for only RJade user or everyone(Codeunit 1)

venu258

Yes, I assigned a company there. As of now I have 2 users only, where vyerragunta is a Super user with access to all companies. I tried onlyfor rjade.