Security Role without dbo in NAV 4 SP3 / SQL Server 2008

timgrant

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

bbrown

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.

timgrant

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

kine

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... ;-)