EXECUTE permission denied on object ’wwfS

Post Reply

Page <12

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
skaue Members Profile Find Members Posts Mod Builder Group Joined: 26 October 2003 Location: Norway Status: Offline Points: 16	Post Options Post Reply Quote skaue Report Post Thanks(0) Quote Reply Posted: 26 October 2003 at 2:43am
	how did you solve this problem... I have the same problem on my host

Morrison Members Profile Find Members Posts Newbie Joined: 15 June 2003 Location: Israel Status: Offline Points: 8	Post Options Post Reply Quote Morrison Report Post Thanks(0) Quote Reply 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.

skaue Members Profile Find Members Posts Mod Builder Group Joined: 26 October 2003 Location: Norway Status: Offline Points: 16	Post Options Post Reply Quote skaue Report Post Thanks(0) Quote Reply 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

Post Reply	Page <12

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum