Autorisation and table session

(0) Share

Report

Posted on by Frédéric MORNAY

Hello,

I'm french so sorry for my mistakes:

We just set up NAV and we start managing permissions. I have this error message but I can not find the table 229, the message to the connection is:

The following SQL server error or errors occured when accessing the session table: 229, "42000" , [Microsoft] [ODBC SQL server Driver] [SQL server] L'autorisation SELECT a été refusée sur l'objet "Session" , base de données "TestRH", schéma "dbo".

Thank you if you have an answer

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Autorisation and table session

YOu might want to look a the Sql security Model - and use "Standard" instead of "Enhanced".

Enhanced has seemed to be a thorn in many implementations.

Also check out these post too:

dynamicsuser.net/.../149786.aspx

www.mibuso.com/.../viewtopic.php
Mohana Yadav 60,157 Super User 2025 Season 1 on at

Like (0)

Report

Re: Autorisation and table session

www.mibuso.com/.../viewtopic.php