Difference SQL 2000 - Native: roles, db size

rondraeq
Member Posts: 4
Hi two questions for Native to SQL 3.7:
- Database size in SQL is roughly 2/3 (29 GB) compared to Native (45 GB). What would explain this difference?
- Security Roles linked to a company seem more strict in SQL
Example: Item Card, in Native database Access was granted based on company specific and a few global Role permissions.
In SQL environment opening the Item Card give the message there are no permissions to read the "Item Ledger Entry". It is easy to add this to the roles, my question is why is this behaviour different in SQL compared to Native?
- Database size in SQL is roughly 2/3 (29 GB) compared to Native (45 GB). What would explain this difference?
- Security Roles linked to a company seem more strict in SQL
Example: Item Card, in Native database Access was granted based on company specific and a few global Role permissions.
In SQL environment opening the Item Card give the message there are no permissions to read the "Item Ledger Entry". It is easy to add this to the roles, my question is why is this behaviour different in SQL compared to Native?
0
Answers
-
1) Size - on SQL just Indexes for keys marked as MaintainSQLINdex=True are created. On Native Server all keys are created.
2) Size - if you have created the SQL from NAV Backup and you are creating this DB with the original, do not forget that the original is not optimized but the new one is, because the indexes were created from scratch and there is no defragmentation etc.
3) On MS SQL the permissions are more strict if you are using Extended security model. Change it to Standard model - it is much better because the permission synchronization process will not need so long time to run.0 -
Thanks for your reply Kine, I am surprised by the size difference between the SQL and Native database.
About standard security model, how is this set in SQL 2000 (Nav 3.7), there is no Advanced tab at alter database.0 -
3.7 did not have the choice of security model, that was not until 4.0 SP2 I believe0
-
Thanks for your reply Denster, I believe so too, considering the lack of information I was able to find on the subject.
Is there a way to adapt SQL 2000 to be less strict so security roles and permissions work similar to Native 3.7? Or is adjusting the roles en permissions the way to handle it?
Working with a setting like in point 3 in Kine's post is appealing.0 -
ah, I forgot the NAV version you are using... than it means you are already using the "standard" security model... 8)
Still, on the MS SQL sometime NAV needs the wider permissions because if NAV wants to check if some table is empty, than you need to have permissions to read that table. In native server, NAV knows that the table is empty and after that it is not checking the permissions for reading the table...0 -
kine wrote:3) On MS SQL the permissions are more strict if you are using Extended security model. Change it to Standard model - it is much better because the permission synchronization process will not need so long time to run.DenSter wrote:3.7 did not have the choice of security model, that was not until 4.0 SP2 I believeRegards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
[Topic moved from Navision forum to SQL General forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!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