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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-06-22 : 00:42:55
|
| Hello All,I created a stored procedure, which my users are not able to see or execute. Those users have db_datareader and db_datawriter access, what am I doing wrong? Please advice. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-06-22 : 01:16:40
|
| Try doing an sp_help on the proc name:sp_help <your proc name>and see what comes up. what shows up as the 'owner'? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-22 : 10:29:26
|
| does users have access to schema in which you created stored procedure? |
|
|
|
|
|
|
Users can not see or execute a stored procedure