Solved

error :SQL0551N

Posted on 2013-05-30
2
1,168 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

911 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

23 Experts available now in Live!

Get 1:1 Help Now