Users in NAV 2013 R2

navuser1

Dear All,

I have seen that a User has the right to access the NAV 2013 R2 database but the same does not exist in the SQL Server.. :-k

A User can able to login(Using Database Server Authentication) in the NAV 2013 R2 system but the user does not exist in User Table (ID 2000000120) in NAV System. :-k

How is it managed in NAV 2013 R2 & SQL architecture ?

thegunzo

Hi

The NAV Middle Tier Service (NAV Server) is started with either "Network Service" or "Domain User" authentication. This user is normally dbowner in the NAV database. NAV Server always uses this authentication to access the NAV database. There is no need fo a NAV User to exist in the NAV database and no need to have any access to the SQL server. This enables NAV to use custom users (NAVUserPassword method) without the need to create a SQL users.

A Developer must have dbowner access to the NAV database and access to the SQL server. To be able to verify table changes http://www.dynamics.is/?p=1619 the developer must either be a NAV user or he must be running the Developement environment as an Administrator and connecting to a NAV Server on the same developement machine.

navuser1

Thanks for the reply.

How does the SQL/NAV manage the no. of CAL user/NAV user(concurrent) ?

navuser1

thegunzo wrote:

There is no need for a NAV User to exist in the NAV database

For the End User or Developer ??

thegunzo

NAV User = End User

No. of CAL is handled in the service tier. Each user only counts as one even if he is using multiple clients.

navuser1

Thanks a lot. =D>

Every NAV user is located only in the User Table (ID 2000000120) of the NAV 2013 R2 System & their assigned role ID(s) are stored in the Access Control Table (ID 2000000053).

No. of CAL is handled in the service tier.

The NAV Service tier is able to count SQL CAL

navuser1

Each user only counts as one even if he is using multiple clients.

not concurrently