Re: Stored Proc security

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Mon, 24 Mar 2008 16:29:40 -0700

Arne Garvander (ArneGarvander@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:

How do I grant execute proc privileges in SQL Server 2005?

GRANT EXEC ON some_sp TO nisse -- Grant permission on a single procedure.
GRANT EXEC ON SCHEMA::dbo TO kalle -- Grant perpmission on all procedures in
the dbo schema
GRANT EXEC TO putte -- Grant EXEC permission all procedures in the database.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Stored Proc security
  - From: Arne Garvander

Prev by Date: Re: Obsolete Aliases
Next by Date: Client application running as Network Service
Previous by thread: Re: Stored Proc security
Next by thread: Obsolete Aliases
Index(es):
- Date
- Thread

Relevant Pages

Re: GRANT - Execute SP
... from sysobjects where type = 'P' ... Jasper Smith (SQL Server MVP) ... grant exec to each sp individually, ...
(microsoft.public.sqlserver.security)
Re: Support team security
... Jasper Smith (SQL Server MVP) ... grant exec on dbo.usp_ReadLogins to Support ... and not just the error logs) e.g ...
(microsoft.public.sqlserver.security)