?
Solved

Execute permission denied on object Run Time Error.

Posted on 2014-03-05
7
Medium Priority
?
656 Views
Last Modified: 2014-03-05
Has anyone encountered this error...

Run-Time Error ‘-2147217911 (80040e09)’
‘Execute permission denied on Object ‘ITS_CheckBatchNumber’, database ‘RPR_Dev’, owner ‘dbo’.

I am running vb6 code that interacts with SQL Server 2008 R2.

Any information on what I should check would be very helpful.
Thanks in advance
0
Comment
Question by:tesla764
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
7 Comments
 
LVL 4

Accepted Solution

by:
ravikantninave earned 2000 total points
ID: 39907751
GRANT EXECUTE ON [storedProcName] TO [userName] where storedProcName is the name of your stored proc and userName is the user you want to give rights to
0
 
LVL 4

Expert Comment

by:ravikantninave
ID: 39907756
Use Microsoft SQL Server Management Studio to connect to the SQL Server

Go to database and open its properties. Then go to the Permissions section, select the user account from step 1 and grant Execute permission to it:
0
 

Author Comment

by:tesla764
ID: 39907808
I tried your second suggestion and I don't see any options to grant execute privileges. I only see create and backup options. Should I see execute options?
0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 

Author Comment

by:tesla764
ID: 39907823
I also tried...
GRANT EXECUTE ON ITS_CheckBatchNumber TO 'Mac-Direct\sritsick'

and I got a syntax error. What I am I doing wrong?
0
 

Author Comment

by:tesla764
ID: 39907872
Got the syntax error worked out. This still doesn't fix the problem. Do you think the Admin with full privileges is the only account that can do this?
0
 

Author Comment

by:tesla764
ID: 39907934
I got this fixed. The Grant command worked. What I was doing wrong was granting to the wrong user name.
Thanks, you were a great help. I will close this now and assigned full points to you.
0
 

Author Closing Comment

by:tesla764
ID: 39907938
Thanks, Fantastic help!!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question