Execute permissions Stored Procedures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AdrianDev - 28 Aug 2007 18:01 GMT

Hi,

Can users trusted with data_reader and data_writer through a Windows Group to a database, in addition be granted execute priviledge on any stored procedures in that database, or can they only be granted through the stored procedures properties permissions?

thanks,

Reply to this Message

Erland Sommarskog - 28 Aug 2007 22:37 GMT

> Can users trusted with data_reader and data_writer through a Windows
> Group to a database, in addition be granted execute priviledge on any
> stored procedures in that database, or can they only be granted through
> the stored procedures properties permissions?

In SQL 2000, only by permission to each individual procedure.

In SQL 2005 you can grant EXEC rights on schema level, which then
apply to all executable objects in that schema.

For future questions, please always specify which version of SQL Server
you are using.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

Reply to this Message

AdrianDev - 29 Aug 2007 00:04 GMT

It is SQL Server 2000,

thanks

>> Can users trusted with data_reader and data_writer through a Windows
>> Group to a database, in addition be granted execute priviledge on any
[quoted text clipped - 8 lines]
> For future questions, please always specify which version of SQL Server
> you are using.

Reply to this Message