Re: Permission

From: SQL Server Development Team [MSFT] (
Date: 03/19/03

From: "SQL Server Development Team [MSFT]" <>
Date: Wed, 19 Mar 2003 10:28:28 -0800

Hi Carlos,
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.

    USE <database_name>

    REVOKE ALL FROM <user_x>

Good luck,

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
"Carlos" <> wrote in message
> 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.