mibuso.com

Microsoft Business Solutions online community
It is currently Thu Jun 20, 2013 1:27 pm

View unanswered posts | View active topics


Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Attain

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  What's this MUID? [MUID:PAUW] Previous topic | Next topic 
Author Message
strzzz
 Post subject: Navision & SQL permission question
PostPosted: Wed Jun 06, 2012 10:12 pm 
Offline

Joined: Wed Jun 06, 2012 10:05 pm
Posts: 3
Country: Lithuania (lt)
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
Top
 Profile E-mail  
 
kapamarou
 Post subject: Re: Navision & SQL permission question
PostPosted: Wed Jun 06, 2012 11:52 pm 
Offline

Joined: Thu Nov 27, 2003 2:49 pm
Posts: 1142
Location: Athens
Country: Greece (gr)
User synchronization?

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

Read chapter 4. What's your security model?
Top
 Profile E-mail  
 
strzzz
 Post subject: Re: Navision & SQL permission question
PostPosted: Thu Jun 07, 2012 12:07 pm 
Offline

Joined: Wed Jun 06, 2012 10:05 pm
Posts: 3
Country: Lithuania (lt)
well I forgot to mention that my Navision is Navision Attain 3.60.
we are using navision authentication (not windows auth)..

any thoughts ?
Top
 Profile E-mail  
 
kapamarou
 Post subject: Re: Navision & SQL permission question
PostPosted: Thu Jun 07, 2012 3:11 pm 
Offline

Joined: Thu Nov 27, 2003 2:49 pm
Posts: 1142
Location: Athens
Country: Greece (gr)
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.
Top
 Profile E-mail  
 
strzzz
 Post subject: Re: Navision & SQL permission question
PostPosted: Sat Jun 09, 2012 10:41 am 
Offline

Joined: Wed Jun 06, 2012 10:05 pm
Posts: 3
Country: Lithuania (lt)
could you explain how to "synchronize" roles ? I don't seem to find this function.. thanks
Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 

Board index » Microsoft Dynamics NAV (formerly Microsoft Business Solutions-Navision) » Navision Attain

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: Chinmoy, MBerger and 4 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to:  
cron