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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

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

  1. #1
    Join Date
    Sep 2005
    Posts
    2

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

    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?

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Seems to me like you need to grant execute permissions for your user ID to the SQL Server objects you mentioned.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. Database not properly created
    By Arjuna in forum Database
    Replies: 2
    Last Post: 07-25-2007, 04:22 AM
  2. SQL Server Database Owner
    By Ronald Aranha in forum Database
    Replies: 3
    Last Post: 08-29-2001, 01:14 PM
  3. object ownership. dbo priority
    By Ted Tracy in forum Database
    Replies: 0
    Last Post: 11-13-2000, 04:50 PM
  4. Re: Runtime-error 70 Permission Denied with DCOM
    By Tom Shreve in forum Enterprise
    Replies: 1
    Last Post: 05-04-2000, 11:10 PM
  5. Re: COM object Password Security
    By Tom Shreve in forum Enterprise
    Replies: 0
    Last Post: 04-07-2000, 09:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center