Re: Execute permissions Stored Procedures


It is SQL Server 2000,

thanks

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns999AF0F9C5167Yazorman@xxxxxxxxxxxx
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: Execute permissions Stored Procedures
    ... Group to a database, in addition be granted execute priviledge on any ... stored procedures in that database, or can they only be granted through ... please always specify which version of SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Debugging in VS.NET
    ... > "Cannot debug stored procedures because the SQL Server database is not ...
    (microsoft.public.sqlserver.msde)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)