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
- 269 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
Synchronize NAV -- SQL
hvdhoeven
Member Posts: 99
Hi,
In an earlier post I have asked some questions about SQL-scripting to add users, rights and roles to SQL 2005 and NAV 5.0 (in an educational setting). I still have one question. Maybe you can help me again?
When I perform some actions in NAV I have to synchronize in NAV [Tools-Security-Synchronize All Logins] to SQL Server. When I use scripting In SQL to add users, rights and roles (in SQL and in NAV), do I still have to synchronize (in NAV)? Is it possible to include this in a script for SQL Server? Do you have an example, please?
Thanks again for your effort and contribution.
Kind regards,
Hans van der Hoeven
Avans Hogeschool
University of applied science
The Netherlands
In an earlier post I have asked some questions about SQL-scripting to add users, rights and roles to SQL 2005 and NAV 5.0 (in an educational setting). I still have one question. Maybe you can help me again?
When I perform some actions in NAV I have to synchronize in NAV [Tools-Security-Synchronize All Logins] to SQL Server. When I use scripting In SQL to add users, rights and roles (in SQL and in NAV), do I still have to synchronize (in NAV)? Is it possible to include this in a script for SQL Server? Do you have an example, please?
Thanks again for your effort and contribution.
Kind regards,
Hans van der Hoeven
Avans Hogeschool
University of applied science
The Netherlands
0
Comments
It is best to use the Standard Security Model in Navision (this exists from 4.00SP3). With this you don't need to synchronize anymore.
If you have to synchronize anyway, I think it is best done through Navision. I never heard of someone writing a stored procedure or .sql to do it.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!