SQL Server blocking caused by -- grant on $ndo$ar$

Business Central/NAV Technical Forum
1

Hi Team,

We are experiencing blocking in SQL Server database for NAV, I see following query is holding blocks. Can you guide me how this can be fixed and what caused this statement to run?

GRANT SELECT, INSERT, UPDATE, DELETE ON “OUDSFK$EP Temporary Filter” TO [$ndo$ar$00000CHANGED**FA900003D2B]

2

Welcome to DUG!!!

Look at this links

http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx

http://dynamicsuser.net/blogs/stryk/archive/2010/10/22/solving-blocking-issues-practical-examples.aspx

3

Obviously you are using “Enhanced” Security Model in NAV - I highly recommend to use “Standard” instead! Please refer to the NAV documentation about details!