Security in Navision 4SP1 SQL

Nizar
Member Posts: 61
hello,
I am upgrading my database from navision 2.60 to navision 4SP1 SQL.
In Navision 4SP1 SQL the table autorisation contain object of navision 2.60 which are deleted in version 4SP1 so it is impossible to synchronise connection.
Can you help me
Thank ]
(*,) s
I am upgrading my database from navision 2.60 to navision 4SP1 SQL.
In Navision 4SP1 SQL the table autorisation contain object of navision 2.60 which are deleted in version 4SP1 so it is impossible to synchronise connection.
Can you help me
Thank ]
(*,) s
0
Comments
-
you need to run table Permission table. Filter on
object ID <> 0 and
object Name = ''
this will show you permission for objects that do not exists. Delete them all and run synchronization for just one user.
To run synchronization for just one user. Click on tools->security->database logins
Select the user you want to synchronize. then click on tools->security->synchronize signle user.0 -
thanks now i can synchronise connexion.
When i open a form an error message ocuured that user can't access to table.
I verify that the table exist in his role
can you help me0 -
Did they log out and in after you synchronized their permission?0
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