MS SQL Server security - How can I grant create permission for stored procedures?

Author

How can I grant create permission for stored procedures?

Matthew Speed

2005-07-07, 8:23 pm

My company has an SQL server hosted at a server farm. An outside
consultant is developing some stored procedures to generate some
reports using the data in the SQL Server database that our application
uses.

The developer will have access to the SQL server via Enterprise
Manager using his own login. I need to give him the right to create
stored procedures in a sandbox database while limiting his other
abilities to select only. When I look at the permissions on stored
procedures I see that I can allow or deny the ability to execute them
but I am not sure how to allow stored procedure creation priviledges.

Can this be done?

TIA

Sue Hoegemeier

2005-07-07, 8:23 pm

Grant the user the statement permission, for example:
GRANT CREATE PROCEDURE to SomeUser

-Sue

On Thu, 07 Jul 2005 18:42:17 -0400, Matthew Speed
<mspeed@mspeed.net> wrote:

>My company has an SQL server hosted at a server farm. An outside
>consultant is developing some stored procedures to generate some
>reports using the data in the SQL Server database that our application
>uses.
>
>The developer will have access to the SQL server via Enterprise
>Manager using his own login. I need to give him the right to create
>stored procedures in a sandbox database while limiting his other
>abilities to select only. When I look at the permissions on stored
>procedures I see that I can allow or deny the ability to execute them
>but I am not sure how to allow stored procedure creation priviledges.
>
>Can this be done?
>
>TIA

Sponsored Links