Grant insert authority on view fails with SQLCODE -551

Technote (FAQ)


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.

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS
RDS

Software version:

7.0, 8.0

Operating system(s):

z/OS

Reference #:

1138733

Modified date:

2007-09-25

Translate my page

Machine Translation

Content navigation