Solved

Execute permission denied on object Run Time Error.

Posted on 2014-03-05
7
589 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 500 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

734 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