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.
Re: pass stored procedure parameters in asp ... In Management Studio, open a new query window, logging in with the bettys...account and try to execute the procedure. ... procedure and properties) of voidTran stored procedure and other ... (microsoft.public.inetserver.asp.general)
Re: pass stored procedure parameters in asp ... Yes, I did log in as bettys and execute voidTran, no problem at all. ...account and try to execute the procedure. ... procedure and properties) of voidTran stored procedure and other ... (microsoft.public.inetserver.asp.general)
Re: SQL Server 2005 Stored Procedure security annoyances ... Can you grant an EXECUTE permission on stored procedure?... I have came to the maturity level to stop using the sa account when I ... I mean it is unrealistic to have to manually set for each SP the rights... (microsoft.public.sqlserver.security)
Re: pass stored procedure parameters in asp ...bettys account and try to execute the procedure. ... 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)
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)
