prevent users from modifying tables or data but allow creating and modifying store procedures

From: Zeng (zzy_at_nonospam.com)
Date: 08/31/04

  • Next message: Aaron [SQL Server MVP]: "Re: prevent users from modifying tables or data but allow creating and modifying store procedures" 
    Date: Mon, 30 Aug 2004 15:09:42 -0700

    Hello

    Is there a way in Sql Server to prevent a user from modifying tables or data
    but allow creating and modifying store procedures?
    thanks!!

  • Next message: Aaron [SQL Server MVP]: "Re: prevent users from modifying tables or data but allow creating and modifying store procedures"