Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How do I give a user a permission on a single table in Nav.?
AndreasD
Member Posts: 34
Hello
I use Navision Client and Database Server (not SQL-Server) 4.03
I have a user whom I gave the Super role for the company of a database in Tools, Security, Database Logins => mark the user in question, Roles => select super
=> in the field company I selected the company of the database.
However, I did not give the user the role Super with the company field being empty.
Now the user tries to log in. It seems to go OK at first, he chooses the company and then he has to choose the location. But after he did so he gets the error message
You do not have permission to read the Session table.
Contact your system manager if you need to have your permissions changed.
This message disappears if I give him the Role super without selecting any company.
I suppose that the user does not get the rights on the session table with ID 2000000009.
Is it possible to pass the user the rights on a single table (instead of a role)? Or would I have to create a role with just one right to one object?
With another database in SQL-Server 2005 I could solve this by passing the right on the session view but with Navision Database Server I don't know how to go about this.
It can't be the idea to pass out the rights Super without company to everyone.
Does anyone of you know or solve this some time?
Thank you for letting me know.
I use Navision Client and Database Server (not SQL-Server) 4.03
I have a user whom I gave the Super role for the company of a database in Tools, Security, Database Logins => mark the user in question, Roles => select super
=> in the field company I selected the company of the database.
However, I did not give the user the role Super with the company field being empty.
Now the user tries to log in. It seems to go OK at first, he chooses the company and then he has to choose the location. But after he did so he gets the error message
You do not have permission to read the Session table.
Contact your system manager if you need to have your permissions changed.
This message disappears if I give him the Role super without selecting any company.
I suppose that the user does not get the rights on the session table with ID 2000000009.
Is it possible to pass the user the rights on a single table (instead of a role)? Or would I have to create a role with just one right to one object?
With another database in SQL-Server 2005 I could solve this by passing the right on the session view but with Navision Database Server I don't know how to go about this.
It can't be the idea to pass out the rights Super without company to everyone.
Does anyone of you know or solve this some time?
Thank you for letting me know.
Andreas
0
Comments
what do you mean choose the location ?
Strg-O ==> you pick the company, OK
Now the window (in Incadea/Navision) User Locations List opens, where you have to choose the location of the company in which you want to start your session. In automotive a dealer can have two or more business locations in town.
After that an error message as described pops up if the user is not Super on the database without a company specified.
Regards