How to change ownership of stored procs?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I created my sprocs when signed on as sa, so they're owned by dbo. Now,
when I want to change my query string to use a special Sql-Server account
created just to access this DB, it doesnt have permission to execute the
sprocs. Is there a way to change that? I could have sworn I saw one a
while ago that involved running a query against Master to change a single
value.

Thanks
 
Eric,

Is there an issue with giving that user execute permissions on the sprocs,
rather than changing the owner?

Raymond Lewallen
 
Yeah, it would work to allow the other user to execute them. I gave the
user what I thought were appropriate DB privelages, but the security issue
remains.
 
Back
Top