Autorisation and table session

Hello,

I’m french so sorry for my mistakes:

We just set up Dynamics 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

http://www.mibuso.com/forum/viewtopic.php?t=22969&f=33

Try to synchronize.

Thank you, it is ok

What is the solution please?

The solution was:

Wow wow :!:Do not give normal users the permissions to DB_Owner :!:
Thats fatal :!:

With using 4.03 and standard security model and you read in your source the session table (view), u must grant permissions to this view. All user use database role public. so give under Database → Security → Roles → Database Roles → Public → Securables → Add → Specific Objects → Views → [dbo].Session → Permission Select → Grant. These are steps for SQL 2005.

Easier go to Database → new querywindow → grant select on “Session” to public

Regards