Re: SqlException: EXECUTE permission denied on object

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

From: Jim Hughes (NOSPAMJ3033_at_Hotmail.com)
Date: 05/01/04 

Date: Sat, 1 May 2004 10:08:20 -0700

"Ivan Simurina" <haha@hehe.com> wrote in message
news:c70jvq$7gp$1@ls219.htnet.hr...
>
> "Jim Hughes" <NOSPAMJ3033@Hotmail.com> wrote in message
> news:evQKib5LEHA.2704@TK2MSFTNGP10.phx.gbl...
> > Grant permissions to the stored proc to the user who is trying to
execute
> > it, i.e. ASPNET for a web server.
>
> How do i do that?
>
> thanx
>
>

http://support.microsoft.com/default.aspx?scid=kb;en-us;815154

If you don't have Enterprise Manager, you could use the Web Admin tool at
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en

Relevant Pages

  • executing sproc
    ... establish a new Connection Cnct and open it successfully. ... Before I run the stored proc, I execute a SQL Select ... Dim lcsConnectionString As String ...
    (microsoft.public.data.ado)
  • Re: Optimizer chooses different plans
    ... All our Employee data is from the mainframe, but the mileage_rate table has no mainframe dependency. ... Anyway, still doesn't answer why the code ALWAYS uses the indexes when cut and pasted to QA, but not so when the stored proc is executed. ... > Analyzer and execute it, ... >> After we added the hints it worked for a while but now does table scans. ...
    (microsoft.public.sqlserver.server)
  • NullPointerExceptions using CallableStatement
    ... I have come across the following problem using the SQLServer 2000 JDBC ... We are using a CallableStatement to execute the ... stored proc, however, unless we turn on implicit transactions within ... works without requiring implicit transactions. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Empty Stored Proc takes 8ms to complete?
    ... An empty proc should take less than 1ms to execute end-to-end. ... SQL Server MVP ... We have a custom DLL written in C++ which calls an empty Stored Proc (through ...
    (microsoft.public.sqlserver.server)
  • Re: NullPointerExceptions using CallableStatement
    ... I have come across the following problem using the SQLServer 2000 JDBC ... We are using a CallableStatement to execute the ... stored proc, however, unless we turn on implicit transactions within ...
    (microsoft.public.sqlserver.jdbcdriver)