Grant insert authority on view fails with SQLCODE -551
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.
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.