http://support.microsoft.com/kb/951196
Microsoft Dynamics NAV does not grant the permission on the Session view and the permission on the Database File view to the $ndo$shadow application server role after you change the database security from the Enhanced security to the Standard security
...
SYMPTOMS
After you change the database security of a Microsoft Dynamics SQL Server database from the Enhanced security to the Standard security, Microsoft Dynamics NAV removes the permission on the Session view and the permission on the Database File view permissions for the multiple application server roles. However, Microsoft Dynamics NAV does not grant the permission on the Session view and the permission on the Database File view to the $ndo$shadow application server role as expected.
This problem occurs in the following products: •Microsoft Dynamics NAV 5.0
•Microsoft Dynamics NAV 4.0
Back to the top | Give Feedback
WORKAROUND
To work around this problem, grant the following permissions on the Session view and the Database File view for the $ndo$shadow application server role: •Delete
•Insert
•References
•Select
•Update