Security model 'standard' SQL2000-2005 not db_owner

andy76

Hello,

Please refer to this post on MBS forum:

http://www.microsoft.com/Businesssoluti ... d39e6a5cda

Last post of Daniel Rimmelzwaan (MVP - Dynamics NAV)

"
you can set the security model to 'standard'.
You can do this in File, Database, Alter, on the 'Advanced' tab you can set
the security model. Make sure you don't do this when other people are in the
database.
"

I have these problems I'm interested in solving them.
I don't understand how to make these changes to the security model in
SQL2000 and SQL2005.
I don't find these commands/menu in Enterprise Manager / Management Studio.

Can someone please explain better?

Thank you very much

Andy

nunomaia

Security model is changed in Navision and not directly in SQL Server.

DenSter

Hi Andy,

Sorry I missed your question on the public newsgroup. This is not done on SQL Server, but inside a NAV client. So follow the instructions from within a NAV session, and you should be able to see the option that explained.

Waldo

The reason that it's all being done from within a C/SIDE client is the fact that when you change the security model, a bunch of other things has to be done (creating application role $ndo$shadow ... link it with every user ... blablabla). When you do it in SQL Server (changing the value on $ndo$dbproperty"), these things are not "triggered" (you should never work directly in NAV tables and change data).