Navision & SQL permission question

strzzz
strzzz Member Posts: 5
edited 2012-06-09 in Navision Attain
Hi,
I've manually set up a user "report" with datareader access on Navision database in SQL2000. Time to time this user gets removed from this database "logins" and after that looses all access.
Question: does Navision have some internal cleanup routine to remove all users which are not assigned using Navision UI? Maybe this routine ir part of Database optimization or some other procedure ?
All other databases in same SQL server keep login information without changing, only Navision database is "loosing" manually assigned users. (users assigned in Navision UI are not impacted).

thanks

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    User synchronization?

    http://download.microsoft.com/download/ ... w1isql.pdf

    Read chapter 4. What's your security model?
  • strzzz
    strzzz Member Posts: 5
    well I forgot to mention that my Navision is Navision Attain 3.60.
    we are using navision authentication (not windows auth)..

    any thoughts ?
  • kapamarou
    kapamarou Member Posts: 1,152
    Try and add the user through SQL Managment Studio and then synchronize the roles through Navision. I think the user will be removed from the Database.
  • strzzz
    strzzz Member Posts: 5
    could you explain how to "synchronize" roles ? I don't seem to find this function.. thanks

Categories