Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sindhu sarah
Starting Member
34 Posts |
 Posted - 2011-11-29 : 09:15:21
|
| Hi all,I have an issue with the procedure which has dynamic query.Its executing well from the sql management studio but i am not able to call it from the application VBA.Its throwing error like select permission denied on Vendor table schema 'dbo' .Please let me know the solution for this. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-11-29 : 10:16:11
|
| The user that you are using to connect needs to have permission on any object accessed in dynamic sql.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Select permission denied dbo