IBM Support

Grant insert authority on view fails with SQLCODE -551

Question & Answer


Question

The user does not get insert authority on the view. This is the error received: DSNT408I SQLCODE = -551, ERROR: WW44N DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION GRANT INSERT ON OBJECT WW44N.WCSSVPOL Why does DB2 deny GRANT INSERT authority? The person running the script has SYSADM authority. This table or view is one in a long list of tables or views that were created, but only this GRANT failed.

Answer

In the view, a column might appear more than once. This duplication generates the unexpected error code. When the view is corrected, the grant works.

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"RDS","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.0;8.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21138733