Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 271 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
Options
no permision to read database table (2000000048) in 4.0
BGI
Member Posts: 176
When we startup we do some reads in table datababas (2000000048).
We have sql 2000 + navision 3.70 and windows login. Users only have public role on sql.
When we port the installation to 4.0, we are getting this error when a user with only the public role tries to read this table.
When we give the user dbowner role, everything is OK, but i don't want every user to be dbowner.....
Anyone experienced the same thing, and found a way around it or the correct security setting?
The user in navision itself has a SUPER role (for the moment)...
Rgds
Benny
We have sql 2000 + navision 3.70 and windows login. Users only have public role on sql.
When we port the installation to 4.0, we are getting this error when a user with only the public role tries to read this table.
When we give the user dbowner role, everything is OK, but i don't want every user to be dbowner.....
Anyone experienced the same thing, and found a way around it or the correct security setting?
The user in navision itself has a SUPER role (for the moment)...
Rgds
Benny
Rgds
Benny Giebens
Benny Giebens
0
Comments
have you tried to place the read permission for the table 2000000048 in the codeunit/table you do the reads on the database table?
Arhontis
https://forum.mibuso.com/search
But to folow up, we got an answer from Microsoft.
If you add new permissions in 4.0 sql, you need to syncronize. At that stage roles are created on the sql site, creating all the necessary tables specified.......except virtual tables.
So if you have a role with tabledata 0 in it, it does not give you all the privileges to all tables. Some tables you need to specify in addition to tabledata 0, such as the table with databases, sessions and some others...
Microsoft specified that this is NOT a bug, but a feature..which isn't described in any document....
But we have now a workaround...
Thnx
Benny Giebens
Benny Giebens