IBM Support

SQL0551N SQL error -551

Troubleshooting


Problem

What should I do if I receive SQL error -551? The error message is: SQL0551N "" does not have the privilege to perform operation "" on object "". Explanation: Authorization ID "" attempted to perform the specified "" on "" without the proper authorization.

Resolving The Problem

The WebSphere MQ Workflow installation contains a tool named "fmczddba" to set the correct authorizations. Do the following to solve the problem (assuming the default names and user ID mqm) :


1. endmqm -i FMCQM
2. fmcclean
3. fmczddba -d FMCQM mqm
4. strmqm FMCQM
5. runmqtrm -m FMCQM -q FMCTRIGGER &
6. fmcamain &

[{"Product":{"code":"SSVLA5","label":"WebSphere MQ Workflow"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"}],"Version":"3.6","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21008755