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
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Navision - SQL Server - Stored Procedures - sp_setapprole
cdennis
Member Posts: 6
I have Navision many users and many Companies. I need to allow some of my Navision users to continue their access to the data via the Navision application but at the same time I need to allow for FAR MORE RESTRICTED access to the SQL Database when ever those same NT Authenticated Navision users access the database direct through some other tools (such as Microsoft Access)
a. Can you execute Stored Procedures from within Attain/Navision
b. Can/has anyone accessed Navision after invoking sp_setapprole stored procedure?
a. Can you execute Stored Procedures from within Attain/Navision
b. Can/has anyone accessed Navision after invoking sp_setapprole stored procedure?
0
Comments
Last week, I have a same question like you.
a. No, You can't execute SP within Naision standard.
b. It can't either.
I think you should use ADO within Visual Basic to access stored procedure in Navision MS.SQL DB. I still haven't try it too... :oops:
Hope this helps,
Jemmy