Re: execution permission on procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 04/21/04 

Date: Wed, 21 Apr 2004 15:58:53 +0200

A user only need exec permission on the stored procedure in order to execute that procedure and having that do
the modification. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Panos" <anonymous@discussions.microsoft.com> wrote in message
news:549F1B60-BD7A-4BE5-8FB3-7ABFA82DA36C@microsoft.com...
> Does anybody know if there is exec permission on a SP and the SP modifies a table, does this mean that a
User must have grant access to the SP and the table to ececure successfully or only the sp permission will do?
>
> Thanks,
>
> Panos.

Relevant Pages

  • Re: Granting EXEC for read only SPs
    ... clearly understanding which stored procedures the user should have rights to ... problem is that the stored procedure is running under its own rights ... I created database role 'X' and granted EXEC permission for all SPs. ... the ones that modify data. ...
    (microsoft.public.sqlserver.security)
  • Re: job security
    ... To start a job a user needs permissions on the sp_startjob stored procedure ... By default the publice role has exec permission on that stored ...
    (microsoft.public.sqlserver.server)
  • Re: Stored Procedure and Table permissions
    ... execute permissions on the stored procedure. ... >given the user EXEC permission for the stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Stored Procedure and Table permissions
    ... the stored procedure reads specific data from a table - ... given the user EXEC permission for the stored procedure. ... Is there a way to configure permissions so that the user ... Bob Mooney ...
    (microsoft.public.sqlserver.security)
  • Re: Create user.....
    ... But if the applicaiton relies on stored procedures, ... all the user needs is EXEC permission on the procedures. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)