Re: Execute permissions Stored Procedures

AdrianDev (adriano@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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.


--
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
.

Relevant Pages

  • Re: Unable to view system stored procedures from .NET IDE and unable to debug SQL
    ... But what is the reason for the debug problem I mentioned below? ... try to step into a stored procedure in the Northwind database, ... Run SQL server setup or contact database ... I can't see any system stored procedures in master. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Identical database w/ identical stored procedures?
    ... > creating the maintence nightmare of updating the same stored procedure ... First of all, put your source code, tables, stored procedures and all ... This can be achieved with a help table in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Debugging in VS.NET
    ... > "Cannot debug stored procedures because the SQL Server database is not ...
    (microsoft.public.sqlserver.msde)
  • Re: Query Analyzer Connect Option
    ... the database, but the users only have SELECT access. ... through stored procedures. ... As Mary pointed out, giving users full access to the database, and ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Moving stored procedures
    ... stored procedures will move with the database. ... database in a table called syscomments.,,, so they go automatically. ... Wayne Snyder, MCDBA, SQL Server MVP ... "Michael Beck" wrote in message ...
    (microsoft.public.sqlserver.server)