Adding User To Brand New Company
Jonathan2708
Member Posts: 552
Hi,
We have a Navision 4.00SP1 database (SQL 2000, Windows authentication) with 2 companies and everything has been working fine. We now want to add a 3rd company to the database so we did this under the Administrator user using File-->Company-->New. We then went to the first user and added them as a SUPER role to the new company - they also have an ALL role for all companies. The user then logged out of Navision and back in again but whenever they try to access anything in the new company they get the message 'You do not have permissions to the General Ledger Setup table'. When they exit Navision whilst in the new company they also get the message 'You do not have permissions to the User Setup table'. The user can still access the original 2 companies fine.
Is there some other procedure that needs to be done when adding users to a brand new company? By the way the Administrator user can access the new company fine. This may suggest a SQL permissions problem but normally when this is the case you get a SQL driver error message, not a native Navision error.
Any help appreciated,
Jonathan
We have a Navision 4.00SP1 database (SQL 2000, Windows authentication) with 2 companies and everything has been working fine. We now want to add a 3rd company to the database so we did this under the Administrator user using File-->Company-->New. We then went to the first user and added them as a SUPER role to the new company - they also have an ALL role for all companies. The user then logged out of Navision and back in again but whenever they try to access anything in the new company they get the message 'You do not have permissions to the General Ledger Setup table'. When they exit Navision whilst in the new company they also get the message 'You do not have permissions to the User Setup table'. The user can still access the original 2 companies fine.
Is there some other procedure that needs to be done when adding users to a brand new company? By the way the Administrator user can access the new company fine. This may suggest a SQL permissions problem but normally when this is the case you get a SQL driver error message, not a native Navision error.
Any help appreciated,
Jonathan
0
Comments
-
I know when I look at my license the # of companies I can have is 2 What is yours?0
-
Theoretically new licenses should had unlimited companies0
-
Savatage wrote:I know when I look at my license the # of companies I can have is 2 What is yours?
We too have company 2, but then right below is company unlimited 1
1,100 Company 2
1,140 Company - unlimited 1
I believe Microsoft changed licensing a while ago to allow unlimitied companies in the same database. oN the pricing worksheet it says it is included as part of the fondation layer
Unlimited Companies (Included in Foundation Layer)0 -
Make your superuser not be company specific, and see if he can then access the new company.0
-
Is your superuser dbowner under SQL?
If not you need to do a Synchronize of the user.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Thanks for the replies. We have unlimited companies so that is not an issue. I was afraid we may have to resynchronise.
Jonathan0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 250 Dynamics CRM
- 102 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions