ODBC + SQL Navision database

Nico_Vanhaecke

Hi guys,

Can somebody tell me how to give a user ODBC rights to a navision database (SQL 2005) without giving the user DB_Owner rights ?
Without the DB_Owner rights, the user is getting the error message "Select permission was denied the object xxxx$yyyy".
I don't think it's a good idea to give DB_Owner rights to a normal employee, so I'm looking for a better solution.

Thanks in advance

BR
Nico

Chinmoy

If you just need to read data from SQL Server through an ODBC connection, did you try giving Public rights to the user? I think Public should be good enough to read data.

Chn

Nico_Vanhaecke

Hi,

With granting public rights, it worked perfect.

Thanks
Nico

Chinmoy

You are welcome!

Please do not forget to mark the post as solved..