Exec denied sp_OA* for dbo

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
*Exec denied sp_OA for dbo**

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

March 24th, 2004, 10:44 PM

acdsky

Friend of Wrox

Join Date: Nov 2003

Posts: 141

Thanks: 0

Thanked 0 Times in 0 Posts

Exec denied sp_OA* for dbo

Hi

I had to restore a DB on another SQL server and are having security issues... When trying to save a record into the DB I get an error "Excecute sp_OAUpdate, Permission Denied, master, dbo" As a work around I gave the guest account exec permission to these sp's and the dbo account already had permission.

I have done some basic trouble shooting like checking for orphaned accounts etc which seems to be sorted out.

Any sugestions appreciated.

Regards
Marnus

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
invalid object dbo.split error............	hepsy.i	ASP.NET 1.0 and 1.1 Professional	1	August 8th, 2007 06:31 PM
change table to dbo	hepsy.i	ASP.NET 1.0 and 1.1 Professional	1	August 7th, 2007 07:41 AM
valid dbo; permission to impersonate dbo	est	BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5	5	February 21st, 2007 04:44 AM
how to change owner instead of DBO	beetle_jaipur	SQL Server 2000	1	April 6th, 2006 08:44 AM