Grant create procedure to USERNAME

-----Original Message-----
From: Ferguson, Keena [mailto:[Email Address Removed]
Sent: Wednesday, November 26, 2003 7:39 PM
To: LazyDBA.com Discussion
Subject: Stored Procedures

All,

Thanks in advance for your time and consideration ... I have a user who
wants to write, compile, and test stored procedures ... We have a policy
that only the DBA's have ddladmin rights ... Is there a way around this,
and
if so, one without a great deal effort on the part of the DBA?

Thanks,

Keena Ferguson

Sr. Database Administrator
Comdata Corporation
[Email Address Removed]
615-371-3483
www.comdata.com


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] information contained in this e-mail is confidential and may
be subject to legal privilege. If you are not the intended recipient,
you must not use, copy, distribute or disclose the e-mail or any
part of its contents or take any action in reliance on it. If you have
received this e-mail in error, please e-mail the sender by replying
to this message. All reasonable precautions have been taken to
ensure no viruses are present in this e-mail and the sender cannot
accept responsibility for loss or damage arising from the use of this
e-mail or attachments.
*****************************************************************************

MS Sql Server LazyDBA home page