Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 309 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Permission to execute table 200000073
kell
Member Posts: 6
I am trying to implement the Role Tailored client at one of my sites.
The RTC is running perfectly on the server. When I try to log in to the RTC on the user’s PC I get an error saying I do not have permission to execute table 2000000073 which is the User Personalisation Table in NAV.
The user in NAV has super user access the same as what I have set up against my own login and it is not a license issue.
If I log in to the users computer with my login the RTC runs without issues.
It is because of this that I believe the user does not have sufficient rights to their own computer or possibly the network (also maybe SQL server, but I did try to give them all the same rights as I have in SQL and got the same issue).
Any help would be greatly appreciated.
The RTC is running perfectly on the server. When I try to log in to the RTC on the user’s PC I get an error saying I do not have permission to execute table 2000000073 which is the User Personalisation Table in NAV.
The user in NAV has super user access the same as what I have set up against my own login and it is not a license issue.
If I log in to the users computer with my login the RTC runs without issues.
It is because of this that I believe the user does not have sufficient rights to their own computer or possibly the network (also maybe SQL server, but I did try to give them all the same rights as I have in SQL and got the same issue).
Any help would be greatly appreciated.
0
Comments
So, I suggest, allow that user, specific access rights in SQL Server on which the database exists.
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com
do you have more information on what SQL permissions the user needs to run the RTC?
You do not have to edit anything in SQL Server when you add a new user, you only need to use C/SIDE to add them to WindowsLogins, give them some roles and Synchronize.
You could also try synchronizing the user with the RoleConfig role, in addition to SUPER, to explicitly grant the required permissions against table 200000073.
Alex