Web Wiz Support and Community Forums : EXECUTE permission denied on object ? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 13:51:06 +0000 Thu, 21 Jul 2005 17:29:24 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10212 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[EXECUTE permission denied on object ? : thanks! that worked perfect......]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87452.html#87452 Author: tk123
Subject: 10212
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
]]> Thu, 21 Jul 2005 17:29:24 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87452.html#87452 <![CDATA[EXECUTE permission denied on object ? : Forgot to add... IIRC, the mssql...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87377.html#87377 Author: dpyers
Subject: 10212
Posted: 20 July 2005 at 8:27pm

Forgot to add...
IIRC, the mssql set up for 7.9 allows tyou to specify the sql serverlogin/password. You don't have to use dbo. Don't recall if that was afeature of 7.5 though.
]]> Wed, 20 Jul 2005 20:27:05 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87377.html#87377 <![CDATA[EXECUTE permission denied on object ? : change dbo to the user/account...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87376.html#87376 Author: dpyers
Subject: 10212
Posted: 20 July 2005 at 8:24pm

change dbo to the user/account name for the mssql db you set up.]]> Wed, 20 Jul 2005 20:24:31 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87376.html#87376 <![CDATA[EXECUTE permission denied on object ? : Can someone provide an example? When...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87360.html#87360 Author: tk123
Subject: 10212
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].."?
]]> Wed, 20 Jul 2005 17:41:14 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post87360.html#87360 <![CDATA[EXECUTE permission denied on object ? : The simplest way is to do a search...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post79636.html#79636 Author: WebWiz-Bruce
Subject: 10212
Posted: 23 March 2005 at 11:07am

The simplest way is to do a search and replace on the SQL server setupfile to replace all instences of DBO with your login credentials.]]> Wed, 23 Mar 2005 11:07:42 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post79636.html#79636 <![CDATA[EXECUTE permission denied on object ? : dpyers wrote:A lot of hosts...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post79621.html#79621 Author: dfrancis
Subject: 10212
Posted: 23 March 2005 at 9:45am

Originally posted by dpyers dpyers wrote:

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.
 
more info?
 
I'm getting that same error
]]> Wed, 23 Mar 2005 09:45:44 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post79621.html#79621 <![CDATA[EXECUTE permission denied on object ? : A lot of hosts are locking down...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55622.html#55622 Author: dpyers
Subject: 10212
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.]]> Thu, 29 Apr 2004 12:41:56 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55622.html#55622 <![CDATA[EXECUTE permission denied on object ? : You do not have permisison on...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55571.html#55571 Author: WebWiz-Bruce
Subject: 10212
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.


Edited by -boRg-]]> Thu, 29 Apr 2004 07:52:02 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55571.html#55571 <![CDATA[EXECUTE permission denied on object ? : maybe my common file is...]]> https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55567.html#55567 Author: zadax
Subject: 10212
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

]]> Thu, 29 Apr 2004 07:12:17 +0000 https://forums.webwiz.net/execute-permission-denied-on-object_topic10212_post55567.html#55567