Mega Code Archive

 

Categories / Delphi / ADO Database

 

Ibm db2 cli driver errors sql0551n and sql0805n

Question: [IBM][CLI Driver][DB2/NT] SQL0551N "MYUSERNAME" does not have the privilege to perform "GRANT" on object "NULLID.SQLL16W4". SQLSTATE=42501 What can I do to help address the cause of this error? Answer: The following error may appear either when trying to list tables via a DB2 alias or when a table is chosen to be viewed on an OS/2 or NT DB2 server: [IBM][CLI Driver][DB2/NT] SQL0551N "MYUSERNAME" does not have the privilege to perform "GRANT" on object "NULLID.SQLL16W4". SQLSTATE=42501 [IBM][CLI Driver][DB2/NT] SQL0805N Package "NULLID.SQLL66W4" was not found. SQLSTATE=51002 "GRANT" on object. It may be necessary to issue the following after logging in as the DBA: grant execute on package NULLID.SQLL16W4 TO PUBLIC