'TableData 2000000001' doesn't exist and ndo problems

attardc
Member Posts: 97
I have just migrated my NAV4 SP1 database from SQL 2000 to SQL 2008 through an SQL restore.
I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist.
Users with other roles are getting the error that 'The Execute permission was denied on the object 'xp_ndo_enumusergroups' database 'master' schema 'dbo'
I've registered the ndo procedures, any ideas?
thanks millions!
I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist.
Users with other roles are getting the error that 'The Execute permission was denied on the object 'xp_ndo_enumusergroups' database 'master' schema 'dbo'
I've registered the ndo procedures, any ideas?
thanks millions!
0
Comments
-
You also need to grant execute rights to those esp's for the public role.0
-
[Topic moved from 'NAV Tips & Tricks' to 'SQL General' forum]0
-
0
-
Hello,
'The Execute permission was denied on the object 'xp_ndo_enumusergroups' database 'master' schema 'dbo' meaning that user has not permission to run 'xp_ndo_enumusergroups' stored procedure in master database. If you are database admin then you need to give permission to the user performing the execution like below.
use [master]
GO
GRANT EXECUTE ON [dbo].[XXXXX] TO [UserYY]
On this source ypou have some steps how you can resolve it:
https://www.get-itsolutions.com/the-execute-permission-was-denied-on-the-object/-1
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions