Web Wiz Forums - EXECUTE permission denied on object ’wwfS

Print Page | Close Window

EXECUTE permission denied on object ’wwfS

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=3550
Printed Date: 03 April 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: EXECUTE permission denied on object ’wwfS

Posted By: Morrison
Subject: EXECUTE permission denied on object ’wwfS
Date Posted: 15 June 2003 at 6:51am

i get this error:

EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'DataBaseName', owner 'OwnerName'.

does anybody know what it means?

thanks.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 15 June 2003 at 6:55am

It menas that you don't have sufficient permissions on the SQL server to run stored procedures that are required for the forum.

-------------
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: Morrison
Date Posted: 15 June 2003 at 6:57am

is there anyway to pass it by not using stored procedures?

Posted By: WebWiz-Bruce
Date Posted: 15 June 2003 at 7:24am

Not in the SQL Server version.

-------------
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: Morrison
Date Posted: 15 June 2003 at 7:29am

last question:

when you're talking about "stored procedures" you mean procedures which come with the SQLServer or Procedures that the programer of the this forum created?

Posted By: Morrison
Date Posted: 15 June 2003 at 7:33am

forget it. i understand that this is procedures that the programer create.

i can see that thos procedure are created and on the SQLServer.

can you think of a reason i can create Procedure but can't use them?

thanks

Posted By: WebWiz-Bruce
Date Posted: 15 June 2003 at 7:43am

It's a permssions problem.

-------------
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: Morrison
Date Posted: 15 June 2003 at 7:45am

Ok. i solved it. thanks!

Posted By: skaue
Date Posted: 26 October 2003 at 2:43am

how did you solve this problem... I have the same problem on my host

Posted By: Morrison
Date Posted: 26 October 2003 at 4:57am

in the SQL enteprise manajer go to the "store procedures" section.

the when you click on the properties of each stored procedure you need to change the permissions to "everyone" instead of administrotor (or something like that).

i hope that will help.

Posted By: skaue
Date Posted: 26 October 2003 at 5:07am

Ok, I used SQL Server Enterprise Manager (which I luckily had installed) to remotly connect to the database on my host. I opened stored procedyres and altered the EXEC rights so my dbuser could execute the forums stored procedures...

Next thing I am curious to find out, is wether or not I have to do the same on all tables created by the installscript.... I see my user does not have permissions to do SELECT, INSERT, UPDATE or DELETE.... But perhaps its not needed when the user has access to run the stored procedyres....

Time will tell... :D