Adding windows user group to NAV and assign roles

najja
Member Posts: 67
Dear All,
May be this is one of the simplest queries.
I am trying to add a windows active directory user group (security) into Dynamics NAV and assign roles. I have around 65 users in total from which only 15 will have super user privileges and other elevated privileges. We have created a customised role called "ERPUSER" for the normal users. I have created a user group (security) in my Active Directory called "ERP_Users" and have added all normal users into this group. When I added this group alone into Tools --> Security --> 'Windows Login' in NAV, I am able to synchronize without any error. When the users tries to login, they can see the database in the DB list using windows authentication but cannot login with the error "Invalid User Name / Password". I read somewhere that I can use user groups only to assign roles to the users and need to add individual users into dynamics NAV. I added some of these users along with the user group, gave no roles to the users directly but gave the user group "ERPUSER" role. When I tried to synchronise I get the error:
** Error ***
The following SQL error or errors occured:
15151,"42000",[Microsoft][ODBC SQL Driver] Cannot find the user
'$ndo$ar$000.......', because it does not exist or you dont have permission
SQL:
GRANT SELECT, INSERT, UPDATE, DELETE on "Object" TO [$ndo$ar$000.....]
*** Error End ****
I am not sure what I am doing wrong. All I am trying to do is to avoid adding all the users into NAV and assign role and instead create an AD user group and assign roles to that. I am not sure how this is achieved, or whether this is possible.
Any help is appreciated.
(I read in one of the post about a document 'Security Synchronization in NAV.doc', but unable to find the doc anywhere in partnersource or otherwise)
Regards
Najja
May be this is one of the simplest queries.
I am trying to add a windows active directory user group (security) into Dynamics NAV and assign roles. I have around 65 users in total from which only 15 will have super user privileges and other elevated privileges. We have created a customised role called "ERPUSER" for the normal users. I have created a user group (security) in my Active Directory called "ERP_Users" and have added all normal users into this group. When I added this group alone into Tools --> Security --> 'Windows Login' in NAV, I am able to synchronize without any error. When the users tries to login, they can see the database in the DB list using windows authentication but cannot login with the error "Invalid User Name / Password". I read somewhere that I can use user groups only to assign roles to the users and need to add individual users into dynamics NAV. I added some of these users along with the user group, gave no roles to the users directly but gave the user group "ERPUSER" role. When I tried to synchronise I get the error:
** Error ***
The following SQL error or errors occured:
15151,"42000",[Microsoft][ODBC SQL Driver] Cannot find the user
'$ndo$ar$000.......', because it does not exist or you dont have permission
SQL:
GRANT SELECT, INSERT, UPDATE, DELETE on "Object" TO [$ndo$ar$000.....]
*** Error End ****
I am not sure what I am doing wrong. All I am trying to do is to avoid adding all the users into NAV and assign role and instead create an AD user group and assign roles to that. I am not sure how this is achieved, or whether this is possible.
Any help is appreciated.
(I read in one of the post about a document 'Security Synchronization in NAV.doc', but unable to find the doc anywhere in partnersource or otherwise)
Regards
Najja
0
Answers
-
they can see the database in the DB list using windows authentication but cannot login with the error "Invalid User Name / Password"
Check the password policy for this.Kapil Khanna0 -
Please change the security model to standard.
File->database->alter->Advanced tab->Security Model changed to standard.
In order to do this. Open SQL SMS and set the database to single user first.0 -
The single user option is also available from the NAV classic client, in Database Alter, on the Options tab.0
-
DenSter wrote:The single user option is also available from the NAV classic client, in Database Alter, on the Options tab.
The issue with that option is that if there are other people connected to the database, Navision just hangs.
On sql it has the option to kick other users out when you set it to single users.
So I don't recommend people using that feature, unless they know the bug.0 -
File --> Database --> Alter --> Advanced | Security - Standard
Works like a charm
Thanks a ton, everyone
Najja0 -
[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Thanks a ton Everyone0
-
you are welcome.0
-
najja wrote:File --> Database --> Alter --> Advanced | Security - Standard
Works like a charm
What is the difference between the "Standard" and "Enhanced" security model?0 -
Ian Wilson wrote:najja wrote:File --> Database --> Alter --> Advanced | Security - Standard
Works like a charm
What is the difference between the "Standard" and "Enhanced" security model?
A lot of headache.
On serious note, there a couple of post on this that you can search.0 -
Thanks for the tip: Use site search before posting dumb questions :oops:
I will go and read "Synchronizing Security in Navision 4.0 SP3" which is on the install CD.
Thanks0
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