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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any usable O/R Mapper with support for Stored Procs for data retrieval and updates? 7
SQL Stored Proc's 5
multiple types of queries and stored procedures 1
Problem with Sql Server 3
TableAdapter to create new SQL stored proc with different owner 5
Problems with LINQ and CLR Stored Procedure 1
How to retrieve associated entities using sprocs? 1
.Net stored proc call drop out. 2

Back
Top