Create user with no administrator privileges

hassen_tunisie
hassen_tunisie Member Posts: 3
edited 2011-11-23 in NAV Three Tier
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?

Comments

  • kriki
    kriki Member, Moderator Posts: 9,135
    Some more info like:

    SQL or native?
    SQL version?
    NAV version?
    RTC or classic?
    Windows or DB-login?
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • hassen_tunisie
    hassen_tunisie Member Posts: 3
    Thanks for your reply

    for more information:
    Sql Server 2005
    Microsoft Dynamics Nav 2009 SP1 Classic
    DB-Login
  • kriki
    kriki Member, Moderator Posts: 9,135
    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;
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories