Re: Alter Many Stored Procedures
From: Vinod Kumar (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 12/15/04
- Previous message: Dan Guzman: "Re: Alter Many Stored Procedures"
- In reply to: Dan Guzman: "Re: Alter Many Stored Procedures"
- Next in thread: Dan Guzman: "Re: Alter Many Stored Procedures"
- Reply: Dan Guzman: "Re: Alter Many Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 15 Dec 2004 11:21:31 +0530
Having said that db_owner and db_ddladmin also opens doors to do other ddl
operations on the DB. So be careful in the usage. If you would like to give
specific grants then its a pain staking job of GRANT-ing each SP to the user
account/distribution list.
-- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD http://www.extremeexperts.com Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:Oajgzek4EHA.1260@TK2MSFTNGP12.phx.gbl... > The group needs to be a member of the db_owner or db_ddladmin fixed database > roles. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "SangHunJung" <SangHunJung@discussions.microsoft.com> wrote in message > news:7721EA2E-43D5-49DD-BB58-287F05D77284@microsoft.com... > > Hello, We have SQL2000 (Standard Edition) server running on Win2k server. > > What permission do I need to setup for a developer in order to change many > > stored procedures in ABC database? Developer windows group is added to > > the > > database and grant all permissions (select, insert, delete, update) to the > > group. > > > > Thanks in advance > > SangHun > >
- Previous message: Dan Guzman: "Re: Alter Many Stored Procedures"
- In reply to: Dan Guzman: "Re: Alter Many Stored Procedures"
- Next in thread: Dan Guzman: "Re: Alter Many Stored Procedures"
- Reply: Dan Guzman: "Re: Alter Many Stored Procedures"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
