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 |
|
SreenivasBora
Posting Yak Master
164 Posts |
 Posted - 2006-04-13 : 16:34:25
|
| Hi Guys,Any one can help me ...When I created a Stored Procedure in sql2000. It created successfully.But the owner of the Stored Proc is on my name instead of DBO.What are the owner permissions I need to provide to create Owner of the object (Table\Sp\View\Trigger\Rule) as DBO. Note: My role does not have DB_OWNER Permissions.RegardsJasminWith RegardsBSR |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-04-13 : 17:39:12
|
| You should be able to pre-pend "dbo." (effectively declaring the owner), and have the procedure owned by dbo. This should work if you are a member of db_ddladmin, but I am not certain it will work if you have only been granted the create procedure right. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-13 : 22:20:36
|
| you cannot provide the permissions if you're not dbo.when you create the objects use dbo.objectname format, specifying explicitly the owner of those objectsask your dbo or dba to change the ownership otherwise it is probably intended that way--------------------keeping it simple... |
|
|
|
|
|
|
User Permission to create Stored Proc