ODBC + SQL Navision database

Nico_Vanhaecke
Nico_Vanhaecke Member Posts: 9
edited 2012-06-15 in SQL General
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

Comments

  • Chinmoy
    Chinmoy Member Posts: 359
    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
    Nico_Vanhaecke Member Posts: 9
    Hi,

    With granting public rights, it worked perfect.

    Thanks
    Nico
  • Chinmoy
    Chinmoy Member Posts: 359
    You are welcome!

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

Categories