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 |
|
sherrys
Starting Member
37 Posts |
 Posted - 2003-09-15 : 11:15:53
|
| If you have db_datareader, db_datawriter, and db_ddladmin and you create a stored procedure. You create the stored procedure having the owner of dbo. Because that is how you are instructed to do it. How do you then grant execute permission to yourself so you can run the thing?You are not sysadmin. You are not dbo. And now you aren't even the object owner.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-15 : 11:56:07
|
| Well, you can't. You need to talk to the sysadmin to grant this. Instead of creating a dbo object, why not create one that is owned by your account instead that way you have the permissions?Tara |
 |
|
|
|
|
|
grant execute