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 |
|
tedew
Starting Member
22 Posts |
 Posted - 2005-10-19 : 09:29:58
|
| hello,I have a problem with my stored procedure :( I wrote some procedures and they don't work when other users are loged. they work only if I'm loged , in application is error " can't find stored procedure " I think it's the problem with owner of the strode procedure - I'am the ownerHow can I do these procedures to able for another users ???bye,sorry for my english :) |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-19 : 09:35:32
|
| When crating the Stored Procedure create it by using dboCreate Procedure dbo.yourSP()so that every user can use that sp by using dbo.yourSPMadhivananFailing to plan is Planning to fail |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-10-19 : 09:49:44
|
quote:
Originally posted by madhivanan
so that every user can use that sp by using dbo.yourSP
I'm sure madhivanan knows this but just to be clear to tedew: dbo.SPs can be execed by every user -- even if they omit the dbo prefix. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-19 : 09:53:02
|
Yes Thats Good Point Sam  But When you create Function using dbo, then you cant use it without specifying the ownerSo it will be safer to use owner name MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Stored Procedure Owner