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 |
|
mind_grapes
Yak Posting Veteran
71 Posts |
 Posted - 2009-09-04 : 06:53:45
|
| Hi all, hope you can help with this.For some reason i cant see the execute option on my stored procedures? any idea why this might be?regardsMG |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-04 : 07:00:38
|
| i think the loginuser has only datareader and datawriter options only and there is no view permissions |
 |
|
|
mind_grapes
Yak Posting Veteran
71 Posts |
Posted - 2009-09-04 : 07:04:02
|
Hi thanks for the quick reply. So i should add view permissions?regardsMGquote:
Originally posted by bklr
i think the loginuser has only datareader and datawriter options only and there is no view permissions
|
|
|
|
mind_grapes
Yak Posting Veteran
71 Posts |
Posted - 2009-09-04 : 07:07:14
|
| Hi, Ive just checked database role membership and the two options that are checked are db_datareader, dnb db_datawriter, but i cant see anything that say view?RegardsMG |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-09-04 : 07:16:31
|
| GRANT VIEW DEFINITION TO [loginname]REVOKE VIEW DEFINITION TO [loginname] |
|
|
|
|
|
|
no execute option on my stored procedure