mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 7:52 am

View unanswered posts | View active topics


Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  What's this MUID? [MUID:A4YN] Previous topic | Next topic 
Author Message
timgrant
 Post subject: Security Role without dbo in NAV 4 SP3 / SQL Server 2008
PostPosted: Tue Jun 21, 2011 7:59 pm 
Offline

Joined: Mon Feb 26, 2007 3:26 am
Posts: 8
Location: Belfast
Country: United Kingdom (uk)
Hi,

Can anyone tell me is it possible to give Security permissions to a user without giving them db_owner on the database. i.e.

they have in Navision:
SUPER (DATA)
ALL
SECURITY

and on SQL Server they have maybe (windows authentication) securityadmin, datareader, datawriter, public, but NOT db_owner permissions. I can't get it to work.

Anyone ever come across this?

Thanks in advance,

Tim
Top
 Profile  
 
bbrown
 Post subject: Re: Security Role without dbo in NAV 4 SP3 / SQL Server 2008
PostPosted: Tue Jun 21, 2011 9:36 pm 
Offline

Joined: Tue Jun 07, 2005 5:24 pm
Posts: 2574
Location: MA
Country: United States (us)
The only SQL role a "not admin" NAV user needs is Public. They should not be granted any other Database or Server roles in SQL.

_________________
There are no bugs - only undocumented features.

Top
 Profile E-mail  
 
timgrant
 Post subject: Re: Security Role without dbo in NAV 4 SP3 / SQL Server 2008
PostPosted: Tue Jun 21, 2011 11:57 pm 
Offline

Joined: Mon Feb 26, 2007 3:26 am
Posts: 8
Location: Belfast
Country: United Kingdom (uk)
Hi,

Thanks for the reply, I'm aware of that and have tried that, I was trying everything above public to get the permission to work as I still get a general SQL Permission error when I try to synchronise as a Security admin (without being dbo).

Thanks,

Tim
Top
 Profile  
 
kine
 Post subject: Re: Security Role without dbo in NAV 4 SP3 / SQL Server 2008
PostPosted: Wed Jun 22, 2011 6:14 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Thu Oct 16, 2003 8:50 am
Posts: 12265
Location: Brno
Country: Czech Republic (cz)
Of course, to be able to "synchronize" permissions you need to have higher permissions... I recommend to use standard security mode and you do not need to bother with this anymore... ;-)

_________________
Kamil Sacek
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.

Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 

Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

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: