mibuso.com

Microsoft Business Solutions online community
It is currently Wed Jun 19, 2013 2:01 am

View unanswered posts | View active topics


Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 
  What's this MUID? [MUID:4UZA] Previous topic | Next topic 
Author Message
Nico Vanhaecke
 Post subject: ODBC + SQL Navision database
PostPosted: Fri Jun 15, 2012 1:15 pm 
Offline

Joined: Wed Aug 19, 2009 5:08 pm
Posts: 6
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
Top
 Profile E-mail  
 
Chinmoy
 Post subject: Re: ODBC + SQL Navision database
PostPosted: Fri Jun 15, 2012 1:23 pm 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 340
Location: Bangalore
Country: India (in)
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
Top
 Profile E-mail WWW  
 
Nico Vanhaecke
 Post subject: Re: ODBC + SQL Navision database
PostPosted: Fri Jun 15, 2012 2:07 pm 
Offline

Joined: Wed Aug 19, 2009 5:08 pm
Posts: 6
Hi,

With granting public rights, it worked perfect.

Thanks
Nico
Top
 Profile E-mail  
 
Chinmoy
 Post subject: Re: ODBC + SQL Navision database
PostPosted: Fri Jun 15, 2012 2:17 pm 
Offline

Joined: Wed Apr 07, 2004 9:39 am
Posts: 340
Location: Bangalore
Country: India (in)
You are welcome!

Please do not forget to mark the post as solved.. :)
Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 4 posts ] 

Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: