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
C/ODBC and Permissions
tonyduea
Member Posts: 2
Hi. I have a client that wants to give me read only permission to connect through C/ODBC using SQL Server to copy table data. She has given me read and execute permission on all of the tables that I need to read. But I still can't connect (No Permission) unless I use an account with full permission.
I have no knowledge of Navision and no access to the security except through the client, so any guidance with what we are forgetting would be appreciated.
I've set the DSN to read-only to try to give them some protection, but a readonly account would be safer.
Thanks,
I have no knowledge of Navision and no access to the security except through the client, so any guidance with what we are forgetting would be appreciated.
I've set the DSN to read-only to try to give them some protection, but a readonly account would be safer.
Thanks,
0
Comments
You also need Execute permission on the System table 9130 C/odbc. Have you been given this?
Regards
Angus