Ошибка при аутентификации

[Anatolyu-]

Ошибка при аутентификации пользователя

Произошла ошибка sql server при обращении к таблице сессия :
229 42000, the select permission was denied on the object 'session'

Почему?

[Anatolyu-]

Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

[finn]

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