Re: Permission

From: SQL Server Development Team [MSFT] (sqldev@microsoft.com)
Date: 03/19/03


From: "SQL Server Development Team [MSFT]" <sqldev@microsoft.com>
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>
    GO

    REVOKE ALL FROM <user_x>
    GO
    GRANT CREATE PROCEDURE <user_x>
    GO

Good luck,
Michael

--
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" <melodesouza@hotmail.com> wrote in message
news:181701c2ee3f$d308e100$a001280a@phx.gbl...
> 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
>