Block company access to users

zen
Member Posts: 8
Dear all,
My customer have two companies in the same database running on v4 SP2 under Sql server 2003 and they want to block access to one company to some users.
My first idea was to block access through the codeunit 1, but the menusuite appears when the user close the error message that I coded. Does anyone know how could I do to prevent users to connect to the company.
Thanks.
zen.
My customer have two companies in the same database running on v4 SP2 under Sql server 2003 and they want to block access to one company to some users.
My first idea was to block access through the codeunit 1, but the menusuite appears when the user close the error message that I coded. Does anyone know how could I do to prevent users to connect to the company.
Thanks.
zen.
0
Answers
-
When you assign users --> roles there is a field for company
go to roles and open the windows or database logins and it should be there,
we use the navtive database, so I am not sure about SQL, but I believe it should work0 -
This is from the on-line help:The Navision security system is company specific and contains information about the permissions that have been granted to each individual user with access to each particular company. This includes information about the roles the users have been given as well as any particular rights that they have been granted as individual users. If you specify that the permissions a user has only apply to a particular company in the database, the user in question will only be able to see that company.
For more information about security in Navision, see the Installation and System Management manual for either Microsoft Business Solutions–Navision Database Server or the Microsoft Business Solutions–Navision SQL Server Option.No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)0 -
I am too stupid….
How I could not see that!!!
Thanks a lot.
zen.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