grant create procedure to <user>



Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com





>From: "Alex Fabio "
><mssqldba-ezmlmshield-x18034332.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: Create Proc Permission
>Date: Wed, 30 Jun 2004 20:59:28 +0000
>Received: from www.websitesondatabases.com ([216.234.186.193]) by
>mc5-f1.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Wed, 30 Jun 2004
>14:01:41 -0700
>Received: (qmail 2403 invoked by uid 121); 30 Jun 2004 21:35:27 -0000
>Received: (qmail 28355 invoked from network); 30 Jun 2004 21:35:27 -0000
>X-Message-Info: JGTYoYF78jFCmov8BJv7andmVzoESt9z
>Mailing-List: contact mssqldba-[Email address protected] run by ezmlm
>Precedence: bulk
>X-No-Archive: yes
>List-Post: <mailto:[Email address protected]
>List-Help: <mailto:mssqldba-[Email address protected]
>List-Unsubscribe: <mailto:mssqldba-[Email address protected]
>List-Subscribe: <mailto:mssqldba-[Email address protected]
>Delivered-To: mailing list [Email address protected]
>Message-ID: <20040630213527.2398.[Email address protected]
>Return-Path: mssqldba-return-6875-MCP111=hotmail.[Email address protected]
>X-OriginalArrivalTime: 30 Jun 2004 21:01:41.0772 (UTC)
>FILETIME=[717C74C0:01C45EE5]
>
>Hi Every One,
>
>Can i give to my developer only create Procedure Permission whithout any
>other privilege.
>
>actually they have Db_reader, DB_Writer, Public
>
>I don't want to give him to modify, drop, create any other object in the
>database.
>
>i want to limit him only Create Procedure Permission.
>
>
>Thanks
>
>_________________________________________________________________
>MSN Premium includes powerful parental controls and get 2 months FREE*
>http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>



MS Sql Server LazyDBA home page