Solved

error :SQL0551N

Posted on 2013-05-30
2
1,147 Views
Last Modified: 2013-07-04
Hi getting this error while accesing the tables: running the commands from db2 client v9.7

SQL0551N "db2v95" does not have the required authorization or privilege
to perform operation "EXECUTE" on object "NULLID.SQLC2H21". SQLSTATE=42501


thought this could be because of bind issues and ran the bind commands, but still same error.
also granted bindadd grant on the db to the user.

followed the following link for solution but still the error is not resolved..
http://www-01.ibm.com/support/docview.wss?uid=swg21440573

Please let me know if I am missing anything?
0
Comment
Question by:jmartin_v
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
Comment Utility
"followed the following link for solution but still the error is not resolved.. "

did you grant execute to public?
0
 

Author Comment

by:jmartin_v
Comment Utility
Hi Momi,

yes granted execute on the object to public as well as to the user
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

11 Experts available now in Live!

Get 1:1 Help Now