EXECUTE permission denied on object ?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10212
Printed Date: 13 April 2026 at 1:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: EXECUTE permission denied on object ?
Posted By: zadax
Subject: EXECUTE permission denied on object ?
Date Posted: 29 April 2004 at 7:12am
|
maybe my common file is currept ? i have 7.5 acces i used the upsize tool to make it sql than i used the Setup sql asp page it run with no error than i tried run the forum and i got that msg : Microsoft OLE DB Provider for SQL Server error '80040e09' EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'zadaxbc_sqldb', owner 'dbo'. /Forum/ver9/common.asp, line 265 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 29 April 2004 at 7:52am
|
You do not have permisison on the MS SQL Server to run the stored procedures. Contact your hosting company. Make sure your MS SWQL Server login is part of the dbo group, your host may need to change this for you. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: dpyers
Date Posted: 29 April 2004 at 12:41pm
|
A lot of hosts are locking down the dbo group. I've been able to change dbo in the SP's to a db login and run the forum with no apparent problems. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: dfrancis
Date Posted: 23 March 2005 at 9:45am
more info?
I'm getting that same error
|
dpyers wrote:Posted By: WebWiz-Bruce
Date Posted: 23 March 2005 at 11:07am
|
The simplest way is to do a search and replace on the SQL server setup
file to replace all instences of DBO with your login credentials.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: tk123
Date Posted: 20 July 2005 at 5:41pm
|
Can someone provide an example?
When I find something like "CREATE TABLE [dbo]..." What do I put instead? "..[username:password].."?
|
Posted By: dpyers
Date Posted: 20 July 2005 at 8:24pm
|
change dbo to the user/account name for the mssql db you set up.
-------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: dpyers
Date Posted: 20 July 2005 at 8:27pm
|
Forgot to add... IIRC, the mssql set up for 7.9 allows tyou to specify the sql server login/password. You don't have to use dbo. Don't recall if that was a feature of 7.5 though. -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: tk123
Date Posted: 21 July 2005 at 5:29pm
|
thanks! that worked perfect... I replaced [dbo] with [username] and all is right in the world again :)
TK
|