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
- 305 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
The role permissions are equal - actual acess differ
Reedberg
Member Posts: 68
Hello experts,
My client uses a custom version of Navision Attain 3.6 and NAV5 as a client.
He has PROD database and a copy of PROD database.
Certain user connects to PROD db and reserves an item in Sales Quote. During reservation system tries to find a record in Item Vendor table and returns an error message: You don't have permission to read Item Vendor table. The roles assigned to the user actually do not allow user to read Item Vendor table, so the error message is clear.
But when the same user connects to the Test db (copy of PROD db), he actually can reserve the very same item in the very same Sales Quote. He can read Item Vendor table. The roles assigned to the user do not differ, I checked it.
My client asks quite a reasonable question - why is it the case that on test environment user can read Item Vendor table and he cannot read it on PROD db. Once again, the roles assigned to the user are the same.
Could you please help me to figure it out? What am I missing?
Any suggestion will be very must appreciated!
My client uses a custom version of Navision Attain 3.6 and NAV5 as a client.
He has PROD database and a copy of PROD database.
Certain user connects to PROD db and reserves an item in Sales Quote. During reservation system tries to find a record in Item Vendor table and returns an error message: You don't have permission to read Item Vendor table. The roles assigned to the user actually do not allow user to read Item Vendor table, so the error message is clear.
But when the same user connects to the Test db (copy of PROD db), he actually can reserve the very same item in the very same Sales Quote. He can read Item Vendor table. The roles assigned to the user do not differ, I checked it.
My client asks quite a reasonable question - why is it the case that on test environment user can read Item Vendor table and he cannot read it on PROD db. Once again, the roles assigned to the user are the same.
Could you please help me to figure it out? What am I missing?
Any suggestion will be very must appreciated!
0
Comments
ad Is License same?
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
two possible causes:
1. The permissions in the roles are different.
2. The code base is not the same as in the test system.
with best regards
Jens
Thank you for the replies, I will check it tomorrow!
I created a new form with a simple button with the following code: I run the form and press the button. I receive an error message on PROD db and I don't receive one on the test-db, so the code base is the same, license files are the same and permissions in the roles are the same (checked it several times).
The only thing I haven't yet done - it's the syncronization (at the moment I don't have enough permissions to perform it). After I obtain the permissions and run the syncronization I will report if it actually solve my issue.
do you have any security filters on the vendor item table? They can have nasty side effects.
with best regards
Jens