Create user with no administrator privileges

hassen_tunisie

Navision is installed on 2 server (TSE server and database server)
actuallay users are using the application by remote desktop

the problem: the application dont work if the user dont have administrator privilege

do someone have solution?

kriki

Some more info like:

SQL or native?
SQL version?
NAV version?
RTC or classic?
Windows or DB-login?

hassen_tunisie

Thanks for your reply

for more information:
Sql Server 2005
Microsoft Dynamics Nav 2009 SP1 Classic
DB-Login

kriki

The following securities are enough:
-In SQL: the user must have public server access and public access on the DB (dbowner if he has to import objects).
-In NAV: In File=>Database=>Alter=>Tab advanced=>set the security model to standard.

PS: it is possible you also need to run the following command on your SQL server:

use master;

GRANT VIEW SERVER STATE to public;