Solved

error :SQL0551N

Posted on 2013-05-30
2
1,199 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
[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
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 500 total points
ID: 39208735
"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
ID: 39209032
Hi Momi,

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

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

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…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

728 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