Solved

Execute permission denied on object Run Time Error.

Posted on 2014-03-05
7
516 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
  • 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL export CSV & schedule It 9 42
PL/SQL query 14 40
sql query 7 35
t-sql sp_addlinkedserver possible risks 3 0
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.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

708 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now