-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Colleagues; I am pleased to report to you that I have apparently resolved this troublesome issue. The steps I took are as follows: SQL Server steps: 1: A new login was created in SQL Server with no domain specification using SQL...
-
Joshi; Thx for the suggestion. I added the user to the Super (data) group, In sql,he has public and db_datareader only. I can log on and access the profile in NAv, so I'm not sure what that tells me. Anyway, it's still having its dbase user mapping disabled after every user security synch. Cheers...
-
Are you assigning NAV permissions to this user? Are they setup as public? This users permissions should be goverened through NAV permissions. Give them the public role and in NAV give the user the role of SUPER (DATA). NAV will then assign SQL read only permissions to that user.
-
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 Folks; We have configured a reporting user on SQL server (NavReportingUser ) which has data read access only. This profile is the profile we are using to enable SQL Server RS reporting over Navision data. It’s a best practice approach...
-
Hello, Using Dynamics NAV 5.0 and SQL 2005. I'm trying to make the Item Card (Object # 27) Read only for some users. I start with a new user with blank roles and permissions. I create a new role and add read only permission to Table Data id # 27 for the Item Card. I then add additional permissions...
-
You could Enhanced security model to overcame that, but you would have to create a matching Navision user and having a longer synchronization process.
-
We're running 5.0 (which may be different), with Database authentication. The table that maps users to their roles is called [dbo].[Member Of]. Do you have that table in 4.0? cheers, Mark