"John Bell" wrote:

> Hi
>
> Unless you explicitly make dbo the owner of the procedure it will be owned
> by the current user. When you execute the stored procedure you should also
> specify the owner as this will aid cache re-use. Check the UID column in
> sysobjects for the procedure it should be 1.
>
> John
>
> "Robert" wrote:
>
> > I am the owner of a database. I am listed as an owner as is dbo. All of the
> > stored procs were owned by dbo. There is a user on the database named
> > EDUser. EDUser was granted execution rights and everything was good. That
> > is until I created a stored proc. EDUser was granted execution rights to the
> > stored proc by me but when it came time to run the proc in my application,
> > Sql Server threw an error number 2812 and says the stored proc cannot be
> > found.
> >
> > I am not the system admin on the machine. What do I need to do to get
> > EDUser to be able to execute this stored proc?
> >
> > Thanks in advance
> > --
> > Robert Hill