Options

Create user with no administrator privileges

hassen_tunisiehassen_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

  • Options
    krikikriki Member, Moderator Posts: 9,090
    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!


  • Options
    hassen_tunisiehassen_tunisie Member Posts: 3
    Thanks for your reply

    for more information:
    Sql Server 2005
    Microsoft Dynamics Nav 2009 SP1 Classic
    DB-Login
  • Options
    krikikriki Member, Moderator Posts: 9,090
    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!


Sign In or Register to comment.