Re: Alter Many Stored Procedures

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/15/04


Date: Tue, 14 Dec 2004 19:45:03 -0600

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 


Relevant Pages

  • Re: Alter Many Stored Procedures
    ... Books Online for SQL Server SP3 at ... >> What permission do I need to setup for a developer in order to change ... >> stored procedures in ABC database? ... Developer windows group is added to ...
    (microsoft.public.sqlserver.security)
  • RE: GRANT Select to all tables on a DB
    ... Are there similar commands to iterate through all the Stored Procs on a ... Sam ... "SangHunJung" wrote: ... >> tables in each database. ...
    (microsoft.public.sqlserver.server)
  • RE: GRANT Select to all tables on a DB
    ... "SangHunJung" wrote: ... >> tables in each database. ... >> can construct a GRANT Select statement. ...
    (microsoft.public.sqlserver.server)
  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)