Re: EXEC Permission

From: Uri Dimant (urid_at_iscar.co.il)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 11:52:52 +0200

Mike
You are not probably an owner of the stored procedure.
So, DBA should grant you 'EXECUTE' permissions on the object

Also ,If you use dynamic sql within the stored procedure it will be forced
you to grant permissions on underlying tables

"Mike L." <globalwebservices2005@yahoo.com> wrote in message
news:ONJfv8pBFHA.1004@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I got this 'EXECUTE permission denied on object <mySproc>' error message
> everytime I try executing my SQL server Sproc.
> What's this and how to fix this err?
>
> many thnaks in advance,
> mike
>
>
>

Relevant Pages

  • Re: Logon failed for user ". but only for membership tables in same database that other request wor
    ... I was able to log on to computer b and execute the stored procedure. ... was no error after I corrected the permissions for the user. ... I can access the stored procedure but I can not use membership.validateuser. ... You may use the GRANT statement to grant the EXECUTE permission for a ...
    (microsoft.public.sqlserver.security)
  • Re: Sql Security ?QL
    ... Permissions on indirectly referenced objects are not checked as long as the ... Permissions to use the statementwithin the EXECUTE string are checked at ... See http://www.sommarskog.se/dynamic_sql.html for other dynamic SQL ...
    (microsoft.public.sqlserver.security)
  • Re: SET IDENTITY_INSERT Privileges?
    ... on the stored procedure to get around this. ... stored procedure and the user has execute permissions on the ... How do I grant permission to a SET Statement?? ...
    (microsoft.public.sqlserver.security)
  • Re: Exec permissions on Stored Procedure
    ... If I grant EXEC permissions on a Stored Procedure to a Domain User ... shouldn't they be able to Execute that stored procedure reguardless if they ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions with sp
    ... Users do not need any permissions on tables used in a stored procedure as ... you do not use dynamic SQL ... I programmed a Sp, which I gave permissions to some users to execute, ...
    (microsoft.public.sqlserver.security)