From: SQL Server Development Team [MSFT] (firstname.lastname@example.org)
From: "SQL Server Development Team [MSFT]" <email@example.com> Date: Wed, 19 Mar 2003 10:28:28 -0800
Using the T-SQL GRANT and REVOKE commands, you can first revoke access to
all permissions from the user and then grant the creation of stored
procedures to the user.
REVOKE ALL FROM <user_x>
GRANT CREATE PROCEDURE <user_x>
-- SQL Server Development Team This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. "Carlos" <firstname.lastname@example.org> wrote in message news:email@example.com... > HI, > I want that a user x only have permission to create/edit > stored procedure, no more object, only SP in YYY > datebase.Its possible. What permission i had to grant her. > TIA >