April 14, 2005 at 7:49 am
I am providing access on a development databases.
What Privileges do I need to grant a user to be able to delete a stored procedure? I gave the user datareader/datawriter and dbowner of the database am I missing something?
April 14, 2005 at 7:54 am
db_owner should be fine. What error do you get?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 14, 2005 at 7:55 am
Actually db_ddladmin should be enough why dbo access??
April 14, 2005 at 7:56 am
The user emailed me with the following after I gave him db_owner:
"That was it… funny, I can edit it and add new ones but there’s no “delete” option…
When you right click a stored procedure do you get a delete option?"
April 14, 2005 at 8:00 am
Yes, ddl_admin (or owner of the proc should be sufficient)
What happens when the user fires directly a DROP PROCEDURE statement?
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 14, 2005 at 8:13 am
db owner did the trick. thanks!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply