Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

EXECUTE permission denied on object ''sp_OACreate'', database ''master'', owner ''dbo''. Expand / Collapse
Author
Message
Posted Friday, November 10, 2006 11:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 23, 2009 8:12 PM
Points: 1, Visits: 2

[QUOTE=aish]I want to send email using sql stored procedure.my code is work fine in my local sqlserver account. when I use my online sql server it display this error.

EXECUTE permission denied on object 'sp_OACreate', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OASetProperty', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner 'dbo'.

EXECUTE permission denied on object 'sp_OADestroy', database 'master', owner 'dbo'.

How canI solove this problem?[/QUOTE]

Please let me do fastly.

Post #322055
Posted Friday, November 10, 2006 11:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 09, 2010 9:55 AM
Points: 77, Visits: 104

I'll state the obvious.  Are you sure that the Online SQL Server Account has permissions to execute the stored Procedures?  If the account doesn't have high enough permissions to allow execute of all procedures, you may want to check the permissions of the user to see if it has been granted Execute on those SP's. 

TJP8




Post #322057
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse