Re: sp_OACreate

Purple-Man,

You login must have SA privileges to execute those sp_OA... stored
procedures.

Ilya

<Purple-Man@xxxxxxxxxxx> wrote in message
news:1123772676.419299.256940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I wanted to use sp_OACreate, sp_OAMethod and sp_OADestroy to execute a
> DTS package from a stored procedure. I had the dba (using the sa
> account) create a wrapper stored procedure as recommended in
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_10182004.asp.
> However, when I executed the wrapper stored procedure, I still
> received privilege errors from the underlying sp_oa extended stored
> procedures.
>
> Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 6
> EXECUTE permission denied on object 'sp_OACreate', database 'master',
> owner 'dbo'.
>
> Any ideas on what we could be doing wrong, or any suggested resolutions
> would be appreciated.
>
> Thank you.
>


.

Relevant Pages

  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)
  • RE: Stored Procedure performance
    ... >Subject: RE: Stored Procedure performance ... >>In this way the Stored Procedure would only execute once and not on all ... >>On Behalf Of Colin Dawson ...
    (comp.databases.informix)
  • Re: pass stored procedure parameters in asp
    ... you can use the EXECUTE AS statement to test the ... procedure and properties) of voidTran stored procedure and other ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.general)
Loading